We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

upgrade sql 2000 db to 2005

lbtoadmin
lbtoadmin asked
on
Medium Priority
151 Views
Last Modified: 2012-05-11
Hello,

I'll first preface this by saying that I am by no means a sql database administrator.  What I need to do is upgrade my current sql 2000 db to 2005 standard.  I have both running on my server (2003 Ent w SP2) and would like to remove sql 2000 completely.  

What steps would I need to undertake, and would I have to do a new instance, or will it just upgrade it in the current location?

Thanks,
Comment
Watch Question

Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
take a Full backup and restore it on the destiantion folder then
use this script to
USE [master]
GO
ALTER DATABASE <DATABASE NAME> SET COMPATIBILITY_LEVEL = 100
GO
to change the compatability mode , please have a eye on the Collation mode,
Alpesh PatelSolution Architect at TCS (SAFe®Agilist, TOGAF® Foundation, PSM I®, MCP, MCSD)
CERTIFIED EXPERT

Commented:
You can upgrade using friendly wizard.

Author

Commented:
PatelAlpesh,

Do you mean during the sql 2005 setup wizard where it shows you the db instances and says to select one to upgrade?
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.