sql server replication: SQL 2000 - Detach user database when running replication -- sql server replication

SQL 2000 - Detach user database when running replication

Robert Paynter
1/28/2007 9:58:00 PM

sql server replication: Hi,
We are running SQL 2000 with replication. We want to relocate the 'mdf'
component of the user database being replicated (to another drive) and plan
to use sp_detach and sp_attach procedures.
Can this be done if replication is stopped? Or do I need to completely
delete the replication, do the detach and attach and then re-create the
replication.
Thank you, in advance, for your assistance.
Regards

Re: SQL 2000 - Detach user database when running replication

Robert Paynter
1/29/2007 2:00:00 AM

Hi Paul
Thank you kindly for taking the time to reply to my question, this is much
appreciated.
Regards
Rob

[quoted text, click to view]

Re: SQL 2000 - Detach user database when running replication

Paul Ibison
1/29/2007 9:52:10 AM

Robert - you'll need to disable replication before the detach and attach
(http://msdn2.microsoft.com/en-us/library/ms188769.aspx). Ideally script out
the publication and do a nosync initialization if you can prevent any data
access.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.