SQL Server 2008 Upgrade or Install R2 version

• m.faisal.maqsood

  Grasshopper

  Points: 13

  More actions

  April 17, 2012 at 10:50 pm

  #256567

  I have given a database which doesn't allow to restore to my sql server give me error of database version mismatch

  my SQL server is 2008 build 10.0.5500.0

  while the given database is running on

  SQL server 2008 r2 build 10.5.2500

  now what should i do to use that database?

  Q1: do i need to upgrade from 2008 to 2008 r2 version ?

  Q2: do i need to install ms SQL server 2008 r2 version.?

  i run windows update and currently installed sql server 2008 doesn't update further so i have to download r2 version or what?

• Koen Verbeeck

  SSC Guru

  Points: 259207

  More actions

  April 17, 2012 at 11:51 pm

  #1475157

  It's up to you.

  You can upgrade your SQL Server 2008 instance to 2008R2, or you can install a new 2008R2 named instance.

  Is this locally on your computer or in a business environment?

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP