February 5, 2014 at 6:58 pm
Hi,
I have transactional replication setup from server A to Server B. I need to refresh the data on server B with the data from Server A. I am generating replication scripts for the publisher and subscribers on server A and Server B.I break the replication before the data refresh and then restoring databases from Server A to Server B. If I run the replication scripts on publisher and subscriber after the data refresh will I be good with the replication?
Thanks.
February 5, 2014 at 7:14 pm
Assuming no new transaction have occurred between the backup and the time replication is recreated. You could also re-init the subscriber via a new snapshot (depending on what your publication contains).
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 5, 2014 at 9:49 pm
sql_novice_2007 (2/5/2014)
Hi,If I run the replication scripts on publisher and subscriber after the data refresh will I be good with the replication?
Thanks.
Kind of. What @sync_type are you using?
If you're backing up the database and then restoring it and turning transaction replication on, normally it would re-send all of the published data (and this only happens when you manually start the snapshot agent after you've run that script, unless you added something to the script to do it for you - which is what I do).
On the other hand if you have this set to "replication support only" then it doesn't re-send all the data and will probably just start working.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply