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

Upgrade from SQL Server 2008 SP3 to R2 Expand / Collapse
Author
Message
Posted Wednesday, May 7, 2014 8:28 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, September 26, 2014 6:42 AM
Points: 64, Visits: 279
Hi,

I have an instance that is in version: SQL Server 2008 SP3 ( 10.00.5500 )
I have to restore a database into that instance from another instance that is in a higher version level: SQL Server 2008 R2 SP2 ( 10.50.4000 ).
The restore fails because I am trying to restore from a higher version level.

My question is: Is it possible to upgrade SQL Server 2008 SP3 instance up to SQL Server 2008 R2 SP2 ?
Post #1568503
Posted Wednesday, May 7, 2014 10:17 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Tuesday, November 18, 2014 3:50 AM
Points: 13,991, Visits: 28,373
Can you upgrade 2008 to 2008R2? Yes, absolutely. There may be licensing costs involved. You'll need to contact Microsoft to see what the situation with your license may be.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1568576
Posted Wednesday, May 7, 2014 12:16 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, September 26, 2014 6:42 AM
Points: 64, Visits: 279
Are there anywhere instructions on how to do that ?
Post #1568639
Posted Wednesday, May 7, 2014 12:22 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Tuesday, November 18, 2014 3:50 AM
Points: 13,991, Visits: 28,373
What? On how to upgrade? You get the software for SQL Server and you start clicking Next, Next, Finish. Here's a Microsoft lesson plan that walks you through a lab upgrade.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1568643
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse