Moving SQL Server installation (dbs, logins, replication, jobs, DTS etc) to new server
I need to move an entire SQL Server installation (databases, logins,
replication, jobs, DTS etc) to a new physical server.
What method requires the least manual intervention? Ideally I would like to
not have to reenter user passwords, and the replication to pick up with the
remote SQL Servers where it left off etc.
If I restored master, distribution, msdb and all user databases to the new
server, would that recreate the entire state of the SQL Server installation?
Would I also need to rename the new server with the old server's name?
|