Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Replication (2012)
 Restoring replication database

Author  Topic 

alicewilliam
Starting Member

1 Post

Posted - 2014-07-28 : 10:33:04
I want to restore a backup of a database used in replication. But when I restore using "Keep Replication" settings enabled, some of the replication databases are missing. What should I do to restore all database objects.

andrew321
Starting Member

5 Posts

Posted - 2014-07-31 : 01:36:07
If u want to restore backup database used in replication to another database or server then replication settings can’t be preserved. In this situation u must have recreate all publications and subscriptions after restoring backup.

For your replicated backup database all their replicated database and associated system databases should be properly or regularly backed up. So backup given databases too:

Publication database at Publisher.
Distribution database at Distributor.
Subscription database at Subscriber.
The master and msdb system databases at Publisher, all Subscribers and Distributor etc. All these databases should be backed up at the same time with each other and replication database.

For more info visit: http://msdn.microsoft.com/en-us/library/ms151152
Go to Top of Page
   

- Advertisement -