Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

detach Expand / Collapse
Author
Message
Posted Thursday, June 12, 2008 4:28 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, February 18, 2013 9:50 PM
Points: 119, Visits: 650
I want to detach a database.
but on my server replication is running. That replication is linked with 4 other databases.
How can i detach a database when replication is running.
What are the conditions that i have to check before detaching a database



Thanks,
sandhya
Post #515763
Posted Thursday, June 12, 2008 5:47 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, April 10, 2014 6:15 AM
Points: 344, Visits: 1,530
Hi,

You will need to unpublish the databases that are involved in replication.

The following link should be of use to you.

http://msdn.microsoft.com/en-us/library/ms190794.aspx

Let me know if I can of any further assistance.

Cheers,
John



John Sansom (@sqlBrit) | www.johnsansom.com
Post #515809
Posted Thursday, June 12, 2008 9:41 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 03, 2014 12:46 PM
Points: 1,413, Visits: 4,531
the book answer is you need to stop publication, but i have detached without doing so

make sure you check the box to drop all connections and you might have to do it a few times. worked for me and replication came back when i attached again


https://plus.google.com/100125998302068852885/posts?hl=en
http://twitter.com/alent1234
x-box live gamertag: i am null
[url=http://live.xbox.com/en-US/MyXbox/Profile[/url]
Post #516052
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse