Move database file with replication set

[Poch Reyes]

Hi Guy,

Is there a way to move a database file (say c:\mydb.mdf to d:\mydb.mdf) to a
different drive without making it offline with replication set on the
database?

Thanks,

Poch

[Shirley Kelly [MS]]

Hi Poch,

No, this cannot be done. The master database contains the location of the
other database files. If you take a database offline and move the files to
another location, you won't be able to bring it back online again because
the files cannot be found.

You cannot detach a database that's being replicated.

You should be able to backup and restore the database at the new location,
using the restore options KEEP_REPLICATION and MOVE. This would have to be
done in Query Analyzer because the Enterprise Manager GUI doesn't have the
KEEP_REPLICATION option. Please refer to Books OnLine for more
information about moving database involved in replication.

Regards,
Shirley
SQL Server Support

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.