We help IT Professionals succeed at work.

Upgrade 2000 SQL Server to 2008 R2

Favorable asked
I'm about upgrading a sql server 2000 instance to 2008 r2.

The instance has a database that is 55GB.

Somebody please tell me what are the steps I would need to follow to get the task accomplished with issues afterward.
Watch Question

<<to get the task accomplished with issues afterward.>>   :)

Run upgrade advisor  (2008r2) to identify things to take care of.
Test, test, test before you do it on production.
Attend the compatibility_level of your db http://msdn.microsoft.com/en-us/library/bb510680.aspx
After upgrade : recompile all SP/UDF, reindex, update statistics,

A nasty thing you could have going from 2000 to 2005 (so also 2008r2) is the error 'Ambiguous column name reference' when you have a query with aliased tables but don't always use the alias when using a column in a group by or order by.
=> again test  , test , test



Explore More ContentExplore courses, solutions, and other research materials related to this topic.