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.
| 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 |
 |
|
|
|
|
|
Restoring replication database