sql server replication: Moving distribution database in SQL Server 2000. -- sql server replication

Moving distribution database in SQL Server 2000.

Panos Tsapralis
9/4/2007 2:34:00 PM

sql server replication: We want to move distribution database of a SQL Server 2000 instance on to a
SAN-based file-system without dropping & re-implementing the replication
processes between this publisher instance & its subscribers. Is there a way
to do this? If not, could we achieve our goal by setting up a new SQL Server
2000 instance on a new hardware server with SAN-based file-systems and moving
the distribution database from its default path before setting up any
replication?

TIA,
Panos Tsapralis,
ptsapralis@hotmail.com / ptsapralis@gmail.com

Re: Moving distribution database in SQL Server 2000.

Hilary Cotter
9/4/2007 10:09:54 PM

No, you really have top drop the publications and subscriptions, disable
replication, and then recreate it.

A hack is to start the server in console mode so only the master database is
loaded (sqlservr -c -f (IIRC)), copy the distribution database to the new
location, edit sysdatabases for the new location of the distribution
database.

Make sure you backup all relevant databases before attempting this.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Panos Tsapralis" <Panos Tsapralis@discussions.microsoft.com> wrote in
message news:552FAC4D-B3A7-43ED-B752-DF010FD03628@microsoft.com...
[quoted text, click to view]