locked
Restored failed RRS feed

  • Question

  • Hi,

    While restore full database backup from Sql server 2008 EE R2 to SQL Server 2008 Standard edition it does not allow me to do and it says....

    '' The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00. 1600 . Either restore the database on a server that supports the backup, or use a backup that is compatible with this server''

     

    please let me know is it possible to do that or impossible?

     

    Please do the needful.

    Saturday, June 26, 2010 7:28 AM

Answers

  • Check the dbi version on both servers using

    DBCC

     

    TRACEON (3604)

    DBCC

     

    PAGE (DatabaseName, 1, 9, 3)

    If the database is not too big then u can generate scripts for the objects and then BCP in/out the data

     

     

     



    SQLEnthusiast
    http://sqlsimplified.com/
    Please click the Mark as Answer button if a post solves your problem!
    Saturday, June 26, 2010 12:17 PM
  • Jamanu,

    Error is expected as sql server 2008 is different from sql server 2008 R2. SQL Server Kilimanjaro becomes SQL Server 2008 R2 Akka 2010 :) .... Cannot restore database backup on downgrade versions .

    ---------------
    Thanks,Suhas V

    Saturday, June 26, 2010 1:02 PM
  • Hi

    You cannot restore the database created in higher version of SQL Server  to downgrade ... It is like  you create a database in SQL Server 2008 and tries to restore to SQL Server 2005....


    Best Regards, Uri Dimant http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Sunday, June 27, 2010 5:17 AM
  • If the servers are on the same domain, you could use the copy database wizard instead.

    Alternatively install a SQL Server 2008 Dev ed (comes cheap) in the domain, do the copy database wizard and finally backup this new database to be restored on the SQL Server 2008 Standard

    Keep in mind, you might want to script out any jobs related to the database, and migrate over the accounts using the sp_help_revlogin procedure: http://support.microsoft.com/kb/246133

    Other than this, Uri Dimant MVP is correct in my opinion. Im meerely mentioning a workaround since i'm guessing this is what you really need.


    Regards Marten Rune Microsoft Certified IT Professional Database Administrator/Developer 2008
    Wednesday, July 7, 2010 10:42 AM

All replies

  • I would like to mention one thing i tried both compressin and un-compression backup to restore but

    i failed to do both ways.

    Saturday, June 26, 2010 7:38 AM
  • Check the dbi version on both servers using

    DBCC

     

    TRACEON (3604)

    DBCC

     

    PAGE (DatabaseName, 1, 9, 3)

    If the database is not too big then u can generate scripts for the objects and then BCP in/out the data

     

     

     



    SQLEnthusiast
    http://sqlsimplified.com/
    Please click the Mark as Answer button if a post solves your problem!
    Saturday, June 26, 2010 12:17 PM
  • Jamanu,

    Error is expected as sql server 2008 is different from sql server 2008 R2. SQL Server Kilimanjaro becomes SQL Server 2008 R2 Akka 2010 :) .... Cannot restore database backup on downgrade versions .

    ---------------
    Thanks,Suhas V

    Saturday, June 26, 2010 1:02 PM
  • Hi

    You cannot restore the database created in higher version of SQL Server  to downgrade ... It is like  you create a database in SQL Server 2008 and tries to restore to SQL Server 2005....


    Best Regards, Uri Dimant http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Sunday, June 27, 2010 5:17 AM
  • If the servers are on the same domain, you could use the copy database wizard instead.

    Alternatively install a SQL Server 2008 Dev ed (comes cheap) in the domain, do the copy database wizard and finally backup this new database to be restored on the SQL Server 2008 Standard

    Keep in mind, you might want to script out any jobs related to the database, and migrate over the accounts using the sp_help_revlogin procedure: http://support.microsoft.com/kb/246133

    Other than this, Uri Dimant MVP is correct in my opinion. Im meerely mentioning a workaround since i'm guessing this is what you really need.


    Regards Marten Rune Microsoft Certified IT Professional Database Administrator/Developer 2008
    Wednesday, July 7, 2010 10:42 AM