469,890 Members | 2,121 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,890 developers. It's quick & easy.

Move mdf/ldf files for a replicated database

Can someone lend some assistance in this? It sounds like it should be
able to be done.

We have a large replicated database in SQL 2000. We need to move the
mdf and ldf files to a location on another drive.

Will doing this affect or break replication in any way? Is there any
way to prevent this?

Thanks in advance.

Glenn Dekhayser
Voyant Strategies

Jul 23 '05 #1
1 2683

"gdekhayser" <gd********@voyantinc.com> wrote in message
news:11**********************@l41g2000cwc.googlegr oups.com...
Can someone lend some assistance in this? It sounds like it should be
able to be done.

We have a large replicated database in SQL 2000. We need to move the
mdf and ldf files to a location on another drive.

Will doing this affect or break replication in any way? Is there any
way to prevent this?

Thanks in advance.

Glenn Dekhayser
Voyant Strategies


There are a number of posts about this in
microsoft.public.sqlserver.replication:

http://groups-beta.google.com/group/...rch+this+group

The general answer seems to be that you need to break and recreate your
replication setup, but you might want to post in that group for more
details.

Simon
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by jsale | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.