Wednesday, March 21, 2012

Help! Need to migrate Windows 2000 Server/SQL Server to Windows 2003 Advanced Server/SQL A

We have existing machine runing Windows 2000 Server and SQL Server
2000. We will be buying a larger machine and would like to migrate all
data/processes/DTSs/jobs into new machine which will be running
Windows 2003 Advanced Server + SQL 2000 Advanced Server edition.
Our goal is not only preserve all jobs/data/packages but also leve the
same name of the SQL server.
How can we do that? are there any reliable recepies?
Thanks in advance!
Gene.See if this helps:
http://vyaskn.tripod.com/moving_sql_server.htm
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Gene Fichtenholz" <gfichten@.hotmail.com> wrote in message
news:6c807745.0402231156.2abf1586@.posting.google.com...
We have existing machine runing Windows 2000 Server and SQL Server
2000. We will be buying a larger machine and would like to migrate all
data/processes/DTSs/jobs into new machine which will be running
Windows 2003 Advanced Server + SQL 2000 Advanced Server edition.
Our goal is not only preserve all jobs/data/packages but also leve the
same name of the SQL server.
How can we do that? are there any reliable recepies?
Thanks in advance!
Gene.

No comments:

Post a Comment