I am trying to restore a backup of a replicated database on a standalone server. This standalone server is our disaster recovery machine that is not connected to any network or domain. From the source server, I backed up the master database and replicated (published) database. On the target machine, I restored the master database and it displayed the replicated database in a SUSPECT mode. When attempting to restore the replicated database, SQL Server said it will not drop databases marked as "replicated". I then tried to turn off the "published" category bit in the master sysdatabases table but it is attempting to modify some files in the replicated database which isn't restored yet! How can I restore a replicated database on a backup SQL server that is configured as a generic SQL Server database with no replication or special functions enabled. I have tried the stored procedures sp_removedbreplication and sp_replicationdboption to turn publication off but it cannot open the replicated database (because it's not restored) because some file are not activated?!?! There has got to be a way to do this. Any help would be greatly appreciated!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL Server 7 Replication & Disaster Recovery
- Thread starter romy
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
