upgrade sql 2000 db to 2005

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,
lbtoadminAsked:
Who is Participating?
 
Ramesh Babu VavillaCommented:
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,
0
 
Alpesh PatelAssistant ConsultantCommented:
You can upgrade using friendly wizard.
0
 
lbtoadminAuthor 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?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.