Sunday, February 12, 2012

Can I move SQL Server to a new machine (including master/model/msd

Hi
We are moving a SQLServer environment from one machine to another. (SQL2000
sp3a)
Can I
- Install SQLServer on the new machine
- backup all databases including master, model , msdb + all user databases
on the source machine
- restore all databases (including mast , model, msdb + user databases) on
the destination machine
and expect SQL server to work as it did on my source machine? (Note in my
case the instance name will be different on the destination machine since the
instance name was the same as the machine name in the orig source :
npboffsql2\npboffsql2
Or do I need to follow article 314546 (i.e. only move user databases and
rebuild the missing logins etc?)
Tia,
FloraHi Flora
You could follow http://support.microsoft.com/kb/224071/
If you wish to rename the server itself then you can follow
http://support.microsoft.com/default.aspx?scid=kb;en-us;303774
John
"Flora Seymour" wrote:
> Hi
> We are moving a SQLServer environment from one machine to another. (SQL2000
> sp3a)
> Can I
> - Install SQLServer on the new machine
> - backup all databases including master, model , msdb + all user databases
> on the source machine
> - restore all databases (including mast , model, msdb + user databases) on
> the destination machine
> and expect SQL server to work as it did on my source machine? (Note in my
> case the instance name will be different on the destination machine since the
> instance name was the same as the machine name in the orig source :
> npboffsql2\npboffsql2
> Or do I need to follow article 314546 (i.e. only move user databases and
> rebuild the missing logins etc?)
> Tia,
> Flora|||Thanks John! Thats exactly what I am looking for!
--
Flora
"John Bell" wrote:
> Hi Flora
> You could follow http://support.microsoft.com/kb/224071/
> If you wish to rename the server itself then you can follow
> http://support.microsoft.com/default.aspx?scid=kb;en-us;303774
> John
> "Flora Seymour" wrote:
> > Hi
> >
> > We are moving a SQLServer environment from one machine to another. (SQL2000
> > sp3a)
> >
> > Can I
> > - Install SQLServer on the new machine
> > - backup all databases including master, model , msdb + all user databases
> > on the source machine
> > - restore all databases (including mast , model, msdb + user databases) on
> > the destination machine
> >
> > and expect SQL server to work as it did on my source machine? (Note in my
> > case the instance name will be different on the destination machine since the
> > instance name was the same as the machine name in the orig source :
> > npboffsql2\npboffsql2
> >
> > Or do I need to follow article 314546 (i.e. only move user databases and
> > rebuild the missing logins etc?)
> >
> > Tia,
> > Flora

No comments:

Post a Comment