Re: Moving SQL Server 2000 to a new machine

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Sasan Saidi (SasanSaidi_at_discussions.microsoft.com)
Date: 10/27/04 

Date: Wed, 27 Oct 2004 13:59:06 -0700

I hope your office has carpet all over because it will be easier for you when
they will ask you to do some cleaning...

Anyways, take a test box (make sure they don't try to give you a PDA!),
restore your databases on the test box, export your sql logins from the
source database to the test. Also keep in mind the sql jobs and if you have
any custom sql error msgs, copy them over.

Sasan Saidi

"Jason Robertson" wrote:

> I would be looking for another job at the same time. You know... just in
> case. Also review your contract with the employer ensure that you can't be
> sued if things go wrong, and they probably will. Do testing on another
> machine first. Ask around for a good employment lawyer and it may be a good
> idea to bring a small tape recorder to work to record your conversations
> with superiors. You never know what they may start telling you, if things go
> wrong. You can sue them afterwards. Dont be a ***. Fight for yourself.
> That is just life. Good luck!
>
> "Scott Yu" <Scott Yu@discussions.microsoft.com> wrote in message
> news:028B088B-D36C-40D4-9D47-0B297F0838E4@microsoft.com...
> > 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.
> >
>
>
>

Quantcast