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 2000 Forums
 Import/Export (DTS) and Replication (2000)
 SQL server 2000 Replication

Author  Topic 

gogia.jaswinder
Starting Member

4 Posts

Posted - 2008-07-20 : 00:40:14
My question is
WE have 3 servers attached with one replication server.
If I have to detach and attach the db being replicated on any of these 3 servers, will affect replication on going.
Please advise.

Thanks


jaswinder

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-07-20 : 00:50:48
You will probably need to rebuild replication.

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

Subscribe to my blog
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-20 : 20:53:14
Sql may not let you detach db involved in replication.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-07-20 : 21:55:29
Good point. I believe even on a drop database you get an error if replication is there.

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 -