Afficher un message
Vieux 02/10/2006, 22h48   #1
Laurence Neville
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut 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?


  Réponse avec citation
 
Page generated in 0,04894 seconds with 9 queries