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?
asked Feb 20, 2012 at 11:09 AM in Default
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.
answered Feb 20, 2012 at 01:49 PM
Grant Fritchey ♦♦
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).