MS SQL Server 2005 SP3 Snapshot Replication

Question

Hi,

I have a SQL Server 2005 SP3 instance which will start snapshot replication daily. It's snapshot file size is usually 1 GB but occasionally, the snapshot file size will shrink to 200MB. I had checked the MSsnapshot_history table in the distribution database and the progress somehow jumped from [42%] to [100%] A snapshot for 145 article(s) was generated. In fact I should have 312 articles.

There's no error messages. The runstatus went from In-progress to Success.

Any idea what went wrong ? Please advise.

TIA !

Answer 1

This sounds like a bug. Are there any minidumps in the log directory at the same time as the snapshot agent was running?

---

looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

Answer 2

Hi limssd,

Any progress? You could try to use replication monitor to troubleshoot.

Replication Monitor (Troubleshoot): http://msdn.microsoft.com/en-us/library/ms151746.aspx.

Thanks,
Maggie

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

Answer 3

I'd checked the log directory and there's no mini dumps.

Answer 4

Hi Maggie,

Snapshot monitor is actually reading from the MSsnapshot_history table.