Move mdf/ldf files for a replicated database

[gdekhayser]

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

[Simon Hayes]

Re: Move mdf/ldf files for a replicated database


"gdekhayser " <gdekhayser@voy antinc.com> wrote in message
news:1113794872 .548904.155990@ l41g2000cwc.goo glegroups.com.. .[color=blue]
> 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
>[/color]

There are a number of posts about this in
microsoft.publi c.sqlserver.rep lication:

http://groups-beta.google.com/group/microsoft.public.sqlserver.replication/search?group=microsoft.public.sqlserver.replication&q=move+database+publisher&qt_g=1&searchnow=Search+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