Can you please advise on below questions.

I need to upgrade one sqlserver from version 7.0 to 2008R2 ...How many upgrades i need to go for? Can I upgrade directly from 7.0 to 2008R2 ? OR need to upgrade from 7.0 to 2000 then 2000 to 2005 and there after 2008 R2?

Usually it takes 45 min to 1 hour for one upgrade...or it will take more time since it is 7.0 version?

Does it takes additional time for configuration apart from upgradation?

once upgrade what test checks we need to perform ? how much time it will take?


more ▼

asked Feb 20, 2012 at 11:09 AM in Default

avatar image

user-1930 (yahoo)
12 4 4 4

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

Just a little bit of searching on the Micrososft web site shows this: Version and Edition Upgrades. From 7.0 you can get to 2005. From there you can go to 2008R2. No matter what, you'll have to upgrade between 7.0 and some other version prior to going to 2008R2.

Time is completely dependent on the number and size of databases involved. Be sure you're using the upgrade advisors to validate your database prior to each upgrade. I would also strongly suggest that you do a side-by-side upgrade. This means leaving your 7.0 system in place, creating a new server with 2005 on it, then moving your databases to the 2005 server by BACKUP & RESTORE. Then you can validate that. If you want, you could do an in-place upgrade on the 2005 server because as long as the original 7.0 system is available for immediate recovery you're not risking anything.

more ▼

answered Feb 20, 2012 at 01:49 PM

avatar image

Grant Fritchey ♦♦
137k 20 44 81

If I am wrong please correct me that upgrade path is follow only for check SQL version dependencies with application so if anything is deprecated in higher version which is using by application that can be track.

Otherwise I thing SQL 2000 can directly upgrade to SQL 2008?

How SQL server edition works on upgrade suppose SQL 2000 Enterprise Edition to SQL 2000 standard editon?

Feb 21, 2012 at 04:54 AM Sharma

@Amardeep Yes, you can upgrade to 2008 directly from SQL 2000, but you cannot directly upgrade from 7.0 to 2008R2, which is the actual requirement of the OP. Please visit the link posted by Grant Fritchey, to find out the limitations and "Supported Upgrade Paths"

Feb 21, 2012 at 05:59 AM Usman Butt

@Amerdeep, upgrading from Enterprise to Standard is fine as long as you are using none of the Enterprise functionality. If you are using Enterprise level functionality you will run into problems.

Feb 21, 2012 at 11:36 AM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left

Time can vary on installations and upgrades. I believe supported path is to go SQL 7.0 > SQL 2000 > SQL 2008 R2.

Doing this big of a jump in versions you will probably want to test your application if possible. I would do the upgrade using the detach/attach method. Detach the databases from your 7.0 instance and make a copy of the database files (mdf/ldf). Then attach the copy to a SQL 2000 instance (this will upgrade the database to that version), then detach and reattach it to the SQL 2008 R2 instance. Each time you attach to the higher version the database compatibility will be upgraded, and you will not be able to reverse it (that is why use of a copy is best).

more ▼

answered Feb 20, 2012 at 11:35 AM

avatar image

6.5k 21 25 34

thanks Shawn,

I noticed average it takes 1 to 1.5 hrs for upgrade from 2000 to 2005 or 2005 to 2008 ? will you be able to let me know about average maximun and minimum upgrade time? also can you please confirm on the upgrade is from 7.0 to 2000 to 2008r2? thank you

Feb 20, 2012 at 11:45 AM user-1930 (yahoo)

I would not trust anything you are told on a forum (even by me) and confirm the information yourself. BOL or a quick Google/Bing search will point you to the documentation for SQL Server. Try searching for "SQL Server 2008 R2 upgrade path".

No, I can't give you an estimated time. In a fresh install of SQL Server 2005 I have done at certain times in an 1 hour, other times it has taken me more than 2 or 3 hrs (including patches). It will vary depending on the machine you are installing on.

Feb 20, 2012 at 12:10 PM Shawn_Melton

It's completely dependent on the size of the datases in question. I've upgraded a database in 5 minutes and another in 5 hours. Size was the issue.

Feb 20, 2012 at 01:45 PM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Feb 20, 2012 at 11:09 AM

Seen: 730 times

Last Updated: Feb 21, 2012 at 11:36 AM

Copyright 2017 Redgate Software. Privacy Policy