Afficher un message
Vieux 02/10/2006, 23h35   #2
Nathan H. Omukwenyi
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: Moving SQL Server installation (dbs, logins, replication, jobs, DTS etc) to new server

Hi Laurence,

It might be ful to check out :
http://vyaskn.tripod.com/moving_sql_server.htm

Nathan H. Omukwenyi, MVP [SQL Server]

"Laurence Neville" <laurenceneville@hotmail.com> wrote in message
news:OdQe7zm5GHA.3452@TK2MSFTNGP05.phx.gbl...
>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,04311 seconds with 9 queries