Move replicated database to a new server

I have the intention to move SQLserver (used with dynamic merge replication,
also distributor) from an old server to a new one. Can I copy all the files
to the new server without reconfiguration?
If the server has the same netbios name then restoring master, msdb,
distribution and the published database is a possibility. Have a look in BOL
for the topic "Strategies for Backing Up and Restoring Merge Replication".
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

Move distribution database to another drive?

Is it possible to move a distribution database to another drive without removing replication? I have done some research but I getting mixed answers from Google searches.

Thanks in advance

Dave

I don't know the specifics, but I believe it involves creating a new "data file" on the new drive, then telling SQL Server to decommission the original, moving data to the new file as it goes.

-Ryan / Kardax

|||

Have you tried looking in Books Online before google pages?

ALTER DATABASE...MODIFY FILE should work.

Move distribution data/log files to another drive

I haven't found the definitive answer on how or if this can be done without removing replication. I'm thinking ALTER DATABASE modify_file is the way to go. Anybody know if this will work or a better way to go about it?

Thanks

"Alter database" should work. There is a similar posting.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1619608&SiteID=1

Gary

|||I saw that one. The client ended up adding a file to the new drive and shrinking the original.

Thanks