detach

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » detach

detach

Rate Topic

Display Mode

Topic Options

Author

Message

sandhyarao49

Posted Thursday, June 12, 2008 4:28 AM

SSC-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

John.Sansom

Posted Thursday, June 12, 2008 5:47 AM

Old Hand

Group: General Forum Members
Last Login: Today @ 5:16 AM
Points: 343, Visits: 1,457

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.sqlbrit.com
The SQLBrit Community Forum - "There's so more to being a Data Professional than just technology."

Post #515809

alen teplitsky

Posted Thursday, June 12, 2008 9:41 AM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 8:15 PM
Points: 1,409, Visits: 4,509

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 »

Permissions