January 24, 2003 at 12:00 pm
I have transactional replication going all the time, and asked to 'disable' it for the weekend so they can use the secondary (subscriber) side database for testing.
Can I manually stop the replication agents on the primary server and use the subscriber database as is for a while?
Than, (after testing is done on the subscriber db) just restart the replication agents on the primary server and everything is back to normal?
Thanks in advance.
January 24, 2003 at 4:35 pm
Yes. As long as you stop the distribution agent no changes will be posted to the subscriber. You can leave the log reader running so that it still posts to distribution db, or stop it and leave the transactions in the log (note that your log may grow because they arent being cleared). Only thing to watch is that you don't exceed the expiration period or you will end up having to reinit the subscription.
Alternatively, you could just make a copy of the subscriber using backup/restore, then they can play all they want.
Andy
January 26, 2003 at 10:18 am
Thank you very much for your help.
-Edan
quote:
Yes. As long as you stop the distribution agent no changes will be posted to the subscriber. You can leave the log reader running so that it still posts to distribution db, or stop it and leave the transactions in the log (note that your log may grow because they arent being cleared). Only thing to watch is that you don't exceed the expiration period or you will end up having to reinit the subscription.Alternatively, you could just make a copy of the subscriber using backup/restore, then they can play all they want.
Andy
http://www.sqlservercentral.com/columnists/awarren/
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply