Showing posts with label lend. Show all posts
Showing posts with label lend. Show all posts

Friday, March 9, 2012

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"gdekhayser" <gdekhayser@.voyantinc.com> wrote in message
news:1113794872.548904.155990@.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...arch+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