July 12, 2012 at 7:09 am
Hello there,
Server A: have two databases - DB1(Publisher) and DB2(Subscriber)
Replication is currently working fine for these two databases.
Server B: have two databases - DB1(Publisher) and DB2(Subscriber)
Replication is currently working fine for these two databases.
Now, due to some testing issues, I want to restore copy of DB1(Publisher) from Server1 to Server2.
But I am concerend about replication.
What is best way to keep the replication in-place on Server2?
I am thinking to follow these steps -
- Take backup of database DB1 from Server1
- Disable all the *associated* SQL Server Agent Jobs on DB1, DB2 on Server2
- Restore Database DB1 on Server2 from back in step# 1 (do I need to go for option WITH KEEP_REPLICATION ??)
- Enable SQL Server Agent Jobs on DB1, DB2 on Server2
Can please guide if these steps seems okay?
July 12, 2012 at 9:32 am
I don't think you will have to disable the replication on DB1 server where you are taking a backup.
But on DB2 where you are going to restore the database to, you might have to disable replication jobs.
Once the restore is complete, you can enable the replication jobs on DB2 and re-initialize the subscriber on DB2 by taking a new snapshot.
Blog
http://saveadba.blogspot.com/
July 13, 2012 at 8:22 am
I disabled the jobs on *Server 2* where I am restoring the database.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply