sql 2000 database running within sql2005

Question

Post reply

sql 2000 database running within sql2005

jeffmc123452003

SSC Rookie

Points: 48
More actions
January 15, 2010 at 2:30 pm

#138120

I have a hyland product running sql 2000 withing sql studio. what steps are needed to upgrade it to sql2005. lost here!!

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply

homebrew01 SSC Guru Points: 55553 More actions · Answer 1

More details & more specifc question(s) would help.

Ignacio A. Salom Rangel SSC-Insane Points: 20443 More actions · Answer 2

I agree with homebrew you should be more specific with your question. When you are going to upgrade you can always use the upgrade advisor.

My blog

jeffmc123452003 SSC Rookie Points: 48 More actions · Answer 3

ok, i have sql studio 2005 running on my server and within that the instance of the database says I'm running sql server 8.0. how do i begin to upgrade that to sql 9.0

homebrew01 SSC Guru Points: 55553 More actions · Answer 4

So, you're SQL Management Studio tool on your desktop is running SQL 2005, but you're managing a 2000 database ? Or is your SQL database 2005, but running in 2000 compatibility mode (8.0) ?

Upgrading SQL from 2000 to 2005 can be a bit of a project. You have 2 options:

"Side by Side" migration from one server to a new server (or instance).

"In Place" upgrade in which the 2000 server is directly upgraded to 2005.

There are lots of threads on this topic here that may help you and answer many questions.

jeffmc123452003 SSC Rookie Points: 48 More actions · Answer 5

not to sound stupid or anything but can you direct me to a few links for the inplace upgrade? I just made a vmware image of the server and now i can perfrom it in test mode

thanks in advance

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 6

Answer me these questions:

Is the server currently running SQL Server 2000 or SQL Server 2005?

If running SQL Server 2005, is the database attached to SQL Server 2005 running in 8.0 compatibility mode?

homebrew01 SSC Guru Points: 55553 More actions · Answer 7

jeffmc123452003 (1/22/2010)
not to sound stupid or anything but can you direct me to a few links for the inplace upgrade? I just made a vmware image of the server and now i can perfrom it in test mode
thanks in advance

http://lmgtfy.com/?q=sql+2005+in+place+upgrade

P.S. The more information you give, the better answer you will get.

jeffmc123452003 SSC Rookie Points: 48 More actions · Answer 8

its running both sql200 and sql2005.

my current running databases are running under sql2005

compatibility mode is set to Sql server 2000 (80)

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 9

Some clarification needed here.

A database that's on a SQL 2005 server in compatibility mode 80 is still a SQL 2005 database. It's only that it's behaving like it was still on SQL 2000. A simple ALTER DATABASE to change the compatibility level is all that you need.

Now, is it a single SQL 2005 server with databases in different compatibility levels or do you have a SQL 2000 instance and a SQL 2005 instance?

If you're not sure, run the following, post the results.

SELECT @@version

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

jeffmc123452003 SSC Rookie Points: 48 More actions · Answer 10

jeffmc123452003

SSC Rookie

Points: 48

January 22, 2010 at 12:51 pm

#1107522

select @@version

microsoft sql 2000 8.00

jeffmc123452003 SSC Rookie Points: 48 More actions · Answer 11

select @@version respond with microsoft sql 20000 8.00.2039

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 12

Is there a second SQL instance or is that the only one?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

jeffmc123452003 SSC Rookie Points: 48 More actions · Answer 13

jeffmc123452003

SSC Rookie

Points: 48

January 22, 2010 at 1:24 pm

#1107552

only one that i know of.

thanks

homebrew01 SSC Guru Points: 55553 More actions · Answer 14

In that case, read up on the 2 upgrade methods, then come back if you have questions. You will probably see mention of the Upgrade advisor. It's a useful tool to points out issues you may need to take care of before the upgrade.