Moving SQL Server 2000 to another server

I will be moving the SQL Server 2000 databases from Server A to Server B.
Both the servers will be having the same directory structure. Here is what I
will be doing:
1. Backup and restore master from Server A to Server B
2. Backup and restore msdb and model from Server A to Server B
3. Detach all the user databases from Server A, copy the .mdf and .ldf files
to Server B and attach the databases on Server B.
4. Shut down Server A.
5. Rename Server B to Server A.
Any suggestions will be highly appreciated. Thanks.
If the folder layouts are identical, then you could just shut down Server A,
copy the whole Data folder(s) over and then start up Server B. Just be sure
to run sp_dropserver and sp_addserver when you are done.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"ronnie" <ronnie@.discussions.microsoft.com> wrote in message
news:233B8469-52BB-484B-9ADC-BDC5A81D7081@.microsoft.com...
I will be moving the SQL Server 2000 databases from Server A to Server B.
Both the servers will be having the same directory structure. Here is what I
will be doing:
1. Backup and restore master from Server A to Server B
2. Backup and restore msdb and model from Server A to Server B
3. Detach all the user databases from Server A, copy the .mdf and .ldf files
to Server B and attach the databases on Server B.
4. Shut down Server A.
5. Rename Server B to Server A.
Any suggestions will be highly appreciated. Thanks.
|||Thanks a lot, Tom and Tibor. This was really helpful.
"Tom Moreau" wrote:

> Oh yeah, you're renaming it back to the original. Missed that one. In that
> case, you're OK without those.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "ronnie" <ronnie@.discussions.microsoft.com> wrote in message
> news:026FECD7-11D8-40FA-8161-64786D6D410E@.microsoft.com...
> Thanks for the information. If I am going to rename the server B to server A
> after shutting down server A, what will I achieve by running the
> sp_dropserver and sp_addserver?
> "Tom Moreau" wrote:
> A,
> sure
> I
> files
>
>