Moving distribution database in SQL Server 2000.
-
We want to move the 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,
-
>>>>>>>I have not tried this <<<<<<
Because you can Backup AND restore that database you could doit following these steps:
1. Stop ALL log readers
2. Stop ALL distribution Agents
3. Backup distribution database
4. Restore previous Backup WITH MOVE and put the mdf and ldf files where you want them
5. Re-start previously stoped agents
I don't see why that should not work but again I have not tried it
Good Luck.
Cheers!
* Noel -
- Attach the new SAN drive to the server.
- Stop SQL server.
- Copy the data and log file to the new SAN drive.
- Rename the SAN drive letter to match where the db was and rename the old drive something else.
- Start SQL server.
If you have other db files on the drive, you would of course have to move them as well.
-
I have done this the way noel describes and it works fine.
couple of provisos, script out replication first and stop the various cleanup jobs as well
---------------------------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply