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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-05-12 : 06:55:19
|
| Ricky writes "How i can restore replicated database without disabling and reconfiguring publishing, sobscription and distrubution?" |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2003-05-12 : 08:09:21
|
| Please refer to BOL on "restoring backups of replicated databases":Publication database:In most cases, restoring a backup to the same server and database from which it was created will preserve your replication settings. If the failure you are recovering from required you to completely re-create the database you are restoring into, run sp_replicationdboption or enable the database for transactional and merge publishing before restoring your backup.If you do not run sp_replicationdboption, your replication settings will be lost during the restore operation.Distribution database:You should restore a distribution database only when you are restoring a publishing database, and always to the same server and database. After restoring the distribution database, review the replication agent profiles to confirm they are set as required by the application.Subscription database:After a restore or attach of a transactional subscription database, you should run sp_vupgrade_subscription_tables to ensure that all required objects are created and are the correct version. If you do not run sp_vupgrade_subscription_tables, objects necessary for replication may not exist in the subscription database.HTHFranco |
 |
|
|
|
|
|
Restore replicated database