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
 General SQL Server Forums
 New to SQL Server Administration
 restored replicated db on prod server

Author  Topic 

Darcy
Starting Member

1 Post

Posted - 2011-03-16 : 11:40:57
Greetings,

I have a Sql 2000 server using transaction replication. It's the publisher and distributer with 6 pull subscribers. I restored a backup of the replicated database onto the same server in read only mode and now I can't really delete it. When I try it says I can't delete a publisher with subscribers. When I look at the replication folder in the restored db it looks exactly like the replication folder in the live database. I'm curious if I delete the pull subscribers in this restored database will it modify the subscribers in the live database?

Thank you,
Darcy

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-03-16 : 14:15:47
Run sp_removedbreplication in the newly restored database to remove the publications. Make sure you are in the restored database and not in the production database.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -