Upgrading to SQL 2008 is simple and easy.
First you need to make sure that you have latest service pack applied on your current box, for SQL 2000 it SP4.
Then run SQL 2008 upgrade advisor on current box and resolve all issues report then by upgrade advisor.
Then run the step-up and choose upgrade from SQL 2000 and follow the instructions.
For more details:
http://msdn.microsoft.com/en-us/library/ms143393(SQL.100).aspx
Note: Make sure you first upgrade your staging or development first and then do full testing
No comments:
Post a Comment