Best practices for upgrading SQL2000 to SQL2005

• Mh-397891

  SSCertifiable

  Points: 6704

  More actions

  March 12, 2008 at 1:12 pm

  #204233

  We have clustered production environments with SQL2000, trying to find out what's the best way of upgrading. Any ideas are greatly appreciated. Thanks!

• SanjayAttray

  SSChampion

  Points: 13157

  More actions

  March 12, 2008 at 1:55 pm

  #788778

  http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx

  http://www.sqlservercentral.com/articles/Administration/installingandupgradingtosqlserver2005/1943/

  http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1194265,00.html

  SQL DBA.

• Scalability Doug

  SSCertifiable

  Points: 5351

  More actions

  March 12, 2008 at 8:28 pm

  #788857

  Also check out the Upgrade Advisor at http://www.microsoft.com/downloads/details.aspx?FamilyID=1470e86b-7e05-4322-a677-95ab44f12d75&displaylang=en

  DAB