Re: Moving SQL Server 2000 to another server

27/03/2008, 13h41

Thanks a lot, Tom and Tibor. This was really ful.

"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.
> >
> >
> >
>
>
>

27/03/2008, 13h41	#1 (permalink)
ronnie Messages: n/a Hébergeur:	Re: Moving SQL Server 2000 to another server Thanks a lot, Tom and Tibor. This was really ful. "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. > > > > > > > > >

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email