Home > IT Answers > SQL Server > documents on sql server upgrade from 2000 to 2005
Pslsql
10 pts.
 documents on sql server upgrade from 2000 to 2005
SQL Server backup
Hello, If anyone has following documentation on SQL SERVER UPGRADE FROM 2000 TO SQL SERVER 2005, I will appreciate. 1) Pre-Checklist for the Upgrade 2) Process for the Upgrade 3) Post Check list for the Upgrade Thank you so much. If you kindly email me at cqldba@gmail.com, will appreciate thanks Sam

Software/Hardware used:
ASKED: January 16, 2008  10:30 PM
UPDATED: February 22, 2008  5:43 AM
RELATED QUESTIONS
Answer Wiki:
The basics that you need to deal with are: Full code review Full regreshion test Full backups taken prior to upgrade after all users are off the system. Then do an uninstall and reinstall or an upgrade. Followed by a smoke test prior to release to production. Upgrading from SQL 2000 to SQL 2005 is a major upgrade and should be fully planned out before attempting to do the upgrade. Are you going to upgrade on the existing hardware, or are you going to upgrade the hardware?
Last Wiki Answer Submitted:  January 17, 2008  6:34 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,520 pts.
 

How did your upgrade go?

Denny Cherry
 64,520 pts.