July 14, 2015 at 7:06 am
I generated a snapshot and it completed Successfully.
How do I apply the snapshot so that the data is refreshed?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 14, 2015 at 7:15 am
Mark the subscription for reinitialisation.
Please note you don't need to reinit a subscription unless something has occurred to change the subscriber or it's been offline for longer than the retention period of the publication as the replication will keep it up to date.
Edit: Or the subscription is broken for whatever reason.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 14, 2015 at 8:18 am
GilaMonster (7/14/2015)
Mark the subscription for reinitialisation.Please note you don't need to reinit a subscription unless something has occurred to change the subscriber or it's been offline for longer than the retention period of the publication as the replication will keep it up to date.
Does the first part of your statement include the possibility of a broken subscription?
In the past (SQL 2005), I know I had to reinit a subscription when the subscription broke for whatever reason (there was a lot of stupid going on that year).
July 14, 2015 at 8:20 am
Fixed
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply