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

No comments:

Post a Comment