May 7, 2014 at 8:28 am
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 ?
May 7, 2014 at 10:17 am
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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
May 7, 2014 at 12:16 pm
Are there anywhere instructions on how to do that ?
May 7, 2014 at 12:22 pm
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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply