Side by Side Upgrade to SQL Server 2005 - Steps
The following are the steps to perform Side by Side upgrade from SQL Server 7 or SQL Server 2000 to SQL Server 2005.
1) Take full backup of all the databases in SQL 7 or SQL 2000 for precautionary purpose
2) Script all the logins using http://support.microsoft.com/kb/246133 in SQL 7 or SQL 2000
3) Script all the jobs in SQL 7 or SQL 2000 using the below link http://msdn2.microsoft.com/en-us/library/aa177024(SQL.80).aspx
4) Install SQL Server 2005
5) Detach all the user databases in SQL 7 or SQL 2000 and copy the files
6) Attach all the user databases in SQL 2005
7) Run the script taken in Step 2 to recreate the logins
8) Run the script taken in Step 3 to recreate the jobs
9) Inorder to migrate DTS packages to SSIS you can refer this link, http://www.simple-talk.com/sql/sql-server-2005/dts-to-ssis-migration
10) Once everything is completed login and check the application functionality
The below link is helpful for getting started with upgrading to SQL Server 2005, http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en
Read Complete Article @ here….