Upgrade Checklist from 2000 to 2005

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Upgrade Checklist from 2000 to 2005

Author

Topic

mcmcom
Starting Member

9 Posts

Posted - 2008-03-28 : 13:42:58

hi all,
i have written a small checklist for my upgrades of databases from 2000 to 2005 servers. I was hoping you can take a look and see if im missing something.

TIA

1. Create backup of 2000 Database to a file group
a. Full Backup
b. Overwrite Existing Media Set
c. To File with Extension .BAK
d. Locate backup on DEV @ X:\SqlServer_Data\MSSQL2K5\BACKUP
e. Make sure Backup File Name has _for_2k5_migration.BAK at the end
2. Create Database on SQL Server 2005 System on DEV
a. MYSERVER\DEVELOPMENT2K5
b. Data files go to : X:\SqlServer_Data\MSSQL2K5\DATA
c. Log files go to : X:\SqlServer_Data\MSSQL2K5\LOG
d. Set Compatibility to 80 (SQL SERVER 2000)
3. Restore Backup to 2005 From File
a. Options Tab – Check Overwrite existing database
b. Once Restore is completed set compatibility mode to 90 (Sql Server 2005)
4. Script all Logins to 2K5
a. Go into 2000 server Security -> Logins
b. Script as CREATE TO Clipboard
c. Open query on 2K5 DB
d. Paste and run (Database must be installed on 2K5 first)

i have not done anything about maintenece plans - is this okay as it is or am i forgetting / not knowing anything else!

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-29 : 00:06:20

Also need to move all sql jobs and dts packages if have any.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources