all groups > sql server replication > march 2005 >
You're in the

sql server replication

group:

Moving DB files in replication


Moving DB files in replication Sherpa
3/28/2005 12:30:04 PM
sql server replication: I have a Db which is both a transactional subscriber and publisher.

I need to move the .MDF and LDF files to another drive set.

What is the best way to do this?

Thanks.
Sherpa

Re: Moving DB files in replication Paul Ibison
3/28/2005 7:03:44 PM
Sherpa,
I'd need to check this but have a look at backup and restore using the KEEP
REPLICATION option. You'll need to remove the original database before
restoring the backup and also prevent other users entering data prior to
taking the backup. Dropping the original database should be prevented
because it is replicated, so you'll need to use sp_removedbreplication first
(after the backup). Please check this on a test environment before going for
it. I'll have a look at implementing this to verify as soon as I have a
chance.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

AddThis Social Bookmark Button