none
Error while database restore from (*.bak) file. " System.Data.SqlClient.SqlError. The database was backed up on the server running version 10.50.1600. That version is incompatible with this version which is running 10.00.1600 ".

    Question

  • Case:

    A "*.Bak" file taken from SQL Server 2008 R2  (trail license... as I remember the person telling me that he has got a 180 trial period and then later will apply the license) from a machine running Windows Server 2008 R2 is restored to a machine on Windows Server 2003 R2 with SQL Server 2008 R2 Enterprise Edition.

    And the following error is come across --> " System.Data.SqlClient.SqlError. The database was backed up on the server running version 10.50.1600. That version is incompatible with this version which is running 10.00.1600 ".

    I tried restoring the back on Sql Server 2008 and then later in SQL Server 2008 R2 but still getting the same error.

    Many thanks in advance.

    Friday, April 29, 2011 11:47 AM

Answers

  • You are trying to restore to a SQL 2008 version (10.00), not 2008 R2 (10.50). Check this
    Friday, April 29, 2011 11:51 AM
  • Hi iFarhan,

     

     

    Carlos is right. We can not restore a backup from a higher version of SQL Server on a lower version of SQL Server.

     

    Are the version number of your two SQL Server 2008 R2 instances same? You might consider to update your SQL Server 2008 R2 instance to the later version such as CU6.

     

     

    Thanks,

    Weilin Qiao


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
    Tuesday, May 03, 2011 11:56 AM

All replies

  • You are trying to restore to a SQL 2008 version (10.00), not 2008 R2 (10.50). Check this
    Friday, April 29, 2011 11:51 AM
  • Hi iFarhan,

     

     

    Carlos is right. We can not restore a backup from a higher version of SQL Server on a lower version of SQL Server.

     

    Are the version number of your two SQL Server 2008 R2 instances same? You might consider to update your SQL Server 2008 R2 instance to the later version such as CU6.

     

     

    Thanks,

    Weilin Qiao


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
    Tuesday, May 03, 2011 11:56 AM