Search

Saturday, May 19, 2012

Restoring SQL Server 2008 R2 Backup file to SQL Server 2008

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″ .
Then 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')

Ref: http://www.ginktage.com/2010/10/restoring-sql-server-2008-r2-backup-file-to-sql-server-2008/

No comments:

Post a Comment