Internet

Linux

MAC

PC General

Windows

NOTE! Before using any of those informations, be sure you read the Disclaimer! Thank you.

Home » SQL

Restoring SQL Server 2008 R2 Backup file to SQL Server 2008

Submitted by No Comment

Recently i had to restore a SQL Server 2008 R2 Database to a Database in another machine and i ended up getting the message:

“The Database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running 10.00.1600″ .

hen when exploring the cause of the reason ,i found that the database that i took the backup was from SQL Server 2008 R2 .

It was the same Backup file that was used to restore in another machine and interestingly , the other machine had SQL Server 2008 .

The Version 10.50 is SQL Server 2008 R2 whereas 10.00 is SQL Server 2008.

Also , the same SQL Server Management Studio 2008 was used to access both the server instances ( 2008 and 2008 R2 ) .

It was a bit confusing for me since i was able to access the SQL Server 2008 R2 Express from the SQL Server Management Studio 2008 , but was unable to restore it to the SQL Server 2008 Express ,but then realised that since the on-disk format is different the versions and the restoring the SQL Server 2008 database to SQL Server 2008 R2 is possible . :)

I also had another option to generate the Create SQL Scripts and execute it in SQL Server 2008 and 2005 and it worked fine too :)
To find the version of Microsoft SQL Server 2008 , connect to SQL Server 2008 by using SQL Server Management Studio and execute the query

1
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Here’s a nice reference of the list of SQL Server versions

Related posts:

  1. SQL Server vs. SQL Azure
  2. Buy Microsoft SQL Server 2008 low price | Discount software Microsoft SQL Server 2008
  3. Microsoft SQL Server 2008 x86 x64 buy cheap
  4. How to shrink the transaction log file in SQL Server 2008
  5. 5 Cool New Features in SQL Server 2008 R2

Tips and tutorials references:

como actualizar sql server 2008 r2 developer 10 00 1600 a 10 50 1600 , 10 50 1600 10 00 1600 , sql server 2008 10 00 1600 10 50 1600 , sql server 2008 10 50 1600 a version 10 00 1600 , sql server 2008 enterprise 10 00 1600 скачать , sql server 2008 r2 management studio x64 restoring databases tutorial , sql server management studio 2008 r2 free download for windows 7 32 bit version 10 50 1600 , the database was backed up on a server running version 10 50 1600 that version is incompatible with this server which is version 10 00 1600 , the database was backed up on a server running version that version is incompatible with this server , up grade the ms sql server 2008 r2 management studio version 10 00 1600 to version 10 50 1600 , update sql server 2008 from 10 0 to 10 50 , update sql server express 2008 from version 10 00 1600 to 10 50 1600 , restore db sqlserver 2008 10 50 1600 to 10 00 1600 , microsoft sql express 2008 r2 10 00 1600 , 10 50 1600 sql 10 00 1600 , atualizar 10 00 1600 para 10 50 1600 , database was backed up on a server running version 10 50 win 32bit , download sql server 2008 r2 x86 10 50 1600 , free sql server 2008 (10 00 1600) download , how to backup sql version 10 50 1600 to sql server version 10 00 1600

Leave a Reply