Monday, February 27, 2012

Help!

Hi Experts,

I have 350 GB database hosted on SQL 2000. Can any one tell me, how should I plan to uprade it to SQL 2005?

Regards

Sachin

Sachin -

I would start with running the Upgrade Advisor tool on your current system. You can get the tool and information on running the tool here:

http://www.microsoft.com/downloads/details.aspx?familyid=1470E86B-7E05-4322-A677-95AB44F12D75&displaylang=en

After you have done that - it is always a good idea to take a copy of your database and restore it to a test server running SQL 2005 and test application functionality to confirm things are working as expected before upgrading.

If you have any specific concerns about the upgrade after you run Upgrade Advisor please let me know.

Thanks

AWAL

No comments:

Post a Comment