Moving SQL Server 2000 to a new machine

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Scott Yu (Yu_at_discussions.microsoft.com)
Date: 10/27/04 

Date: Wed, 27 Oct 2004 12:53:02 -0700

Hello all,

Recently I was tasked to move our entire SQL Server 2000 to a new server. I
work as a programmer so I have limited knowledge working with SQL Server, but
not enough to handle the task I been given without direction and assistance.
This is where you people come in. THANKS IN ADVANCE!!!!

Currently our SQL Server 2000 SP2 is running on a NT 4.0 box. The target
server will be running 2003 and we'll need to install SQL Server 2000 service
pack 3. I was wondering if anyone experience the same task and if so, how
you went about moving the entire SQL Server 2000 to the new server? What
problems did you encounter and how you resolved it? Will it be possible to
copy over the system databases from the source SQL Server to the target SQL
Server under a new operating system and service pack and still work? Or will
I have to script out all the system level components and rebuild it on the
target SQL Server and then restore the user databases?

I have to make sure all of our DTS packages, management services, database
maintenance plans, replication and link servers are counted for and in
working order. God help me.

 Any help or links would be greatly appreciated.

Thank you very much.

Relevant Pages

  • Re: why>?
    ... On your desktop-- you'll be running SQL Server behind the scenes. ... it isn't risky to allow end users to create databases. ... it is no more risky than giving you the ability to create spreadsheets. ... I'm not saying that Oracle and IBM are going away. ...
    (microsoft.public.excel)
  • Re: Please answer my queries for fresh Installation
    ... Moving SQL Server Databases ... Using WITH MOVE in a Restore to a New Location with Detach/Attach ... Disaster Recovery Articles for SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: Please answer my queries for fresh Installation
    ... You can restore MSDB as well as master. ... > SQL Server, It will create Master, MSDB databases. ...
    (microsoft.public.sqlserver.server)
  • Re: Moving SQL Server 2000 from NT4.0 to Windows 2003
    ... Detach your existing user databases, ... user databases (or RESTORE) to the new server. ... > Hey Steve, ... Windows 2003 will not allow SQL Server SP less than 3. ...
    (microsoft.public.sqlserver.server)
  • Re: The best elegant solution to override 65k rows limit in a sheet
    ... MDB is friggin dead.. ... SQL Server has taken over the world. ... than read-only access to central company databases. ... I learned to write queries in Access after an hours' ...
    (microsoft.public.excel)