| Roy Harvey 2002-11-11, 4:23 pm |
| Val,
>I am in the process of replacing our current SQL 7.0
>server that is running on Windows NT(on an NT domain) and
>hardware on a Compaq Proliant 6000 to a Compaq Proliant
>DL580 with Windows 2000 as the OS(on an active directory
>domain). The server name cannot change.
>
>Does anyone know the best method for doing this ?
The overall approach I have used is to set up the new server in the
domain, with a different name. Install SQL Server, install all the
databases, get all the logins straightened out, test, test, test.
Then at the time of cutover, dump all the databases on the source
server, load them again on the server, rename the source server (and
change the IP address), rename the target server to the production
name (usually including moving the IP address from the old one). Read
up on renaming SQL Servers ahead of time.
One thing I plan to do in the future, when I am running 2000 instead
of 7.0, is to use named instances instead of the server name. This
should make moves a bit simpler.
Roy
|