Feb 11, 2013 at 3:00 PM
Upgrade SQL 2000 to SQL 2008 R2
Install .Net frame work and Windows Installer 4.5
Install SQL Server 2008R2 and hotfix(SQLServer2008R2_RTM_CU3_2261464_10_50_1734_x86 )
Download and install hotfix
Take the full Backups of all Databases form SQL Server 2000
Transfer the Logins- download sql file run on query analyzer in sql 2000
Copy result and paste on sql 2008 R2 run the result query to transfer login such as counterpa, etc.,
Take Transactional backups of all databases
Stop the SQL Server 2000
Create Newalias name for SQL Server 2008r2 which suppose same as SQL Server 2000 and assign port as 1433
Restored in SQL Server 2008 R2 with NO RECOVER(to reduce the Down time).
Restore Transactonal backup with with Recovery.