So, there's a bug in SQL Server 2005 SP2 _and_ SQL Server 2005 SP3 (fixed in SP2 CU12 and SP3 CU3), where a commonly-used replication SP can inadvertently reset your subscription, and you get the dread "The initial snapshot for publication...is not yet available" error. In my case I couldn't easily snapshot the data across, so a workaround is to sync the data, then recreate the subscription, specifying that it does not need to be initialized.
Bug: MS KB967192
http://support.microsoft.com/kb/967192/EN-US
Fix:
http://technet.microsoft.com/en-us/library/ms151705.aspx
Essentially, what you need to do is drop the subscription, sync the data, then recreate the subscription, making sure to uncheck "Initialize" (if using SSMS).
Tuesday, March 22, 2011
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment