• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 137
  • Last Modified:

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,
0
lbtoadmin
Asked:
lbtoadmin
1 Solution
 
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

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now