Migrating from 2000 to 2005 - help!

[sqlgracie]

Help. I have been tasked with upgrading a 2000 instance to 2005.

I have actually done this before, but it was a long time ago, and I didn't do it alone. Now, the sitation is little different, and I need to know the EXACT steps to take.

Does anyone have a FAQ or link that outlines migration steps? I found one on sql server central, but it isn't very detailed.

One of the important things I need to know is, how do I create a rollback plan if I am upgrading from 2000 to 2005 on the same server (instance)?

Also, should I run the Upgrade Advisor before doing anything?

I seem to recall lots of permissions issues that arose with 2005.

HELP

Thanks

 

[mrdenny]

The first thing that you should do is do a test upgrade on the dev system. Then do it again on a QA system.

When doing an inplace upgrade of SQL 2000 to SQL 2005 be sure kick all the users off the system, then do a full grade. Once SQL 2005 has installed and attached to the databases you won't be able to roll back to SQL 2000 without restoring the databases from the tape backup.

Yes you should run the upgrade advisor before doing anything.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com