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.|||And here's some additional (good) reading:
http://vyaskn.tripod.com/moving_sql_server.htm
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OexzxW2jIHA.484@.TK2MSFTNGP06.phx.gbl...
> 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 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:
> 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.
>
>|||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:
> 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:
> > 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.
> >
> >
> >
>
>