Monday, February 11, 2013

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
sql query

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.