Friday, March 23, 2012

Migrate SQL Server 2000 to a new server

Hi all
My organisation has SQL Server 2000 running on Windows 2000.
We've just had most of our hardware replaced and SQL Server needs to
be transferred to a better machine running Windows Server 2003.
Are there any tools that could help in doing that? In my
understanding, the databases themselves can simply be backed up and
restored on the new machine. But how can all the existing settings,
users and roles be copied to the new server?
ThanksHi Manu,
You may want to take a look at this article. It includes information on how
to move databases, logins and passwords, jobs, DTS packages, etc.
How to move databases between computers that are running SQL Server
http://support.microsoft.com/kb/314546/
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Manu" wrote:

> Hi all
> My organisation has SQL Server 2000 running on Windows 2000.
> We've just had most of our hardware replaced and SQL Server needs to
> be transferred to a better machine running Windows Server 2003.
> Are there any tools that could help in doing that? In my
> understanding, the databases themselves can simply be backed up and
> restored on the new machine. But how can all the existing settings,
> users and roles be copied to the new server?
> Thanks
>|||On Dec 14, 1:13 pm, Ben Nevarez <BenNeva...@.discussions.microsoft.com>
wrote:[vbcol=seagreen]
> Hi Manu,
> You may want to take a look at this article. It includes information on ho
w
> to move databases, logins and passwords, jobs, DTS packages, etc.
> How to move databases between computers that are running SQL Serverhttp://
support.microsoft.com/kb/314546/
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
> AIG SunAmerica
> "Manu" wrote:
>
>
>
Hi Ben
Thanks for the reply.
According to the link, in order to transfer usernames and passwords to
SQL Server running on a different machine, the instance should be
running under a domain account. But that is not the case with our
setup. SQL Server is running under local machine accounts.
Any thoughts?
Thanks|||Manu,
That is only for the DTS Transfer Logins Tasks. You can still use the method
1 of the section 'A complete resolution to transfer logins and passwords
between different versions of SQL Server' and will get the additional benefi
t
of transfering the original login SID.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Manu" wrote:

> On Dec 14, 1:13 pm, Ben Nevarez <BenNeva...@.discussions.microsoft.com>
> wrote:
> Hi Ben
> Thanks for the reply.
> According to the link, in order to transfer usernames and passwords to
> SQL Server running on a different machine, the instance should be
> running under a domain account. But that is not the case with our
> setup. SQL Server is running under local machine accounts.
> Any thoughts?
> Thanks
>|||Manu
http://vyaskn.tripod.com/moving_sql_server.htm
"Manu" <mandeep.sekhon@.gmail.com> wrote in message
news:839ffaa6-d07f-4f5a-a224-4f338dbb55ff@.s19g2000prg.googlegroups.com...
> Hi all
> My organisation has SQL Server 2000 running on Windows 2000.
> We've just had most of our hardware replaced and SQL Server needs to
> be transferred to a better machine running Windows Server 2003.
> Are there any tools that could help in doing that? In my
> understanding, the databases themselves can simply be backed up and
> restored on the new machine. But how can all the existing settings,
> users and roles be copied to the new server?
> Thanks|||On Dec 17, 3:06 am, "Uri Dimant" <u...@.iscar.co.il> wrote:[vbcol=seagreen]
> Manuhttp://vyaskn.tripod.com/moving_sql_server.htm
> "Manu" <mandeep.sek...@.gmail.com> wrote in message
> news:839ffaa6-d07f-4f5a-a224-4f338dbb55ff@.s19g2000prg.googlegroups.com...
>
>
>
>
Hi Uri
Thanks for the reply.
The link that you sent me requires that SQL Server be running on the
same operating system on both the machines.
In my case, however, the OS is changing too. The new machine runs
Windows Server 2003 while the older one was running Windows 2000.|||On Dec 14, 6:09 pm, Ben Nevarez <BenNeva...@.discussions.microsoft.com>
wrote:[vbcol=seagreen]
> Manu,
> That is only for the DTS Transfer Logins Tasks. You can still use the meth
od
> 1 of the section 'A complete resolution to transfer logins and passwords
> between different versions of SQL Server' and will get the additional bene
fit
> of transfering the original login SID.
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
> AIG SunAmerica
> "Manu" wrote:
>
>
>
>
>
>
>
>
>
>
>
>
Hi Ben
That worked beautifully.
As mentioned on the web page, default databases assigned to the logins
are different.
Is there any way to assign the default databases apart from writing a
script using 'sp_defaultdb' for each login?
Regards

No comments:

Post a Comment