I have joined a new project in my company and my new client is going to upgrade their existing SQL Server 2000 to SQL Server 2008. I searched for several articles and they were really helpfull. We have create a checklist (before and after) and steps to be performed for this upgrade. Can anyone help me with any such checklist and steps by step guide. The problem is we are don't have time, we have to start this activity from Monday onwards. Please help me. Thanks.
Seriously, you're starting the upgrade process, but you don't have time to plan it out so that you're protecting your systems? Really? That's practically an actionable statement if you're working as a consultant. Posting it on a public forum could get you into serious trouble, especially if you have problems with the upgrade later. That said, what kind of upgrade are you doing? Are you planning an in-place or side-by-side upgrade? The different approaches will result in different checklists. The safest approach is the side-by-side upgrade. You can do this either by using a backup and restore or dettach/attach of the database files. I'd suggest using the backup & restore as the safer approach. Here are the things I'd do: 1. Run Upgrade Analysis tool from Microsoft. Address any issues raised there, first. 2. Identify DTS packages. These must be migrated by hand, unless you buy PragmaticWorks excellent software. Rebuild the DTS packages as SSIS. 3. Script out all SQL Agent jobs. 4. Script out all security 5. Backup the systems and validate the backups (preferably by restoring them to another system) 6. Run the security script on the new system 7. Run the restore on the new system. 8. Validate the databases by running DBCC 9. Manually update all statistics 10. Run the SQL Agent script In a nutshell, that's it. There may be other details that others will add, but that's basically the approach I've been taking and it works. But you'd better plan, test, and practice before you start hitting production systems if you've never done this before.
There are many resources in this site: search for [upgrade] Here are some of the things you have to remember: Run upgrade advisor first and make sure nothing breaks due to upgrade, TEST throughly, Make sure you have a solid backup, make sure you run DBCC and update your statistics after upgrade, if it is a side by side upgrade dont forget to move logins by scripting them out ...... :