Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2005 to 2008 Upgradation (System Databases) Expand / Collapse
Author
Message
Posted Tuesday, November 5, 2013 3:33 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 9:48 AM
Points: 66, Visits: 171
I want to upgrade SQL 2005 to 2008, i don't want to do in-place migration directly.
we are planning Side by Side Migration only in the Production.

would it work ? if i do in-place migration from SQL 2005 to SQL 2008 for DB Engine Service only,
here my question is... would it change the SQL 2005 System Databases to SQL 2008 format ?

if it is work then i can take the above system databases backup and simply restore into Production SQL 2008.

Any suggestions would be appreciate.

Post #1511417
Posted Tuesday, November 5, 2013 6:37 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 8:12 AM
Points: 2,247, Visits: 2,708
sreenubabu.s (11/5/2013)
I want to upgrade SQL 2005 to 2008, i don't want to do in-place migration directly.
we are planning Side by Side Migration only in the Production.

would it work ? if i do in-place migration from SQL 2005 to SQL 2008 for DB Engine Service only,
here my question is... would it change the SQL 2005 System Databases to SQL 2008 format ?

if it is work then i can take the above system databases backup and simply restore into Production SQL 2008.

Any suggestions would be appreciate.


When you do an in-place upgrade of the DB Engine from SQL 2005 to SQL 2008 the system databases will be upgraded. It can be a valid option for DEV and TEST environment, but be aware the rollback procedure will be quite difficult/extensive. If possible a side-by-side migration is more preferrable.
When you do the side-by-side upgrade on production environment there is NO need to restore the system databases from the DEV/TEST environment. The system databases contain instance-specific information and a restore on another instance could bring the instance down. For the side-by-side upgrade on production environment all you need to do is to restore the user databases, set compatibility level, update usage and statistics, etc.


** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1511464
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse