locked
Restore DB RRS feed

  • Question

  • I am trying to restore the SQL DB its shows the following error...

    System.Data.Sqlclient.sqlerror : The Database was backed up on a server running version 10.50.4000. That version is incompatible with this server, which is running 10.00.5512. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. ( Microsoft.Sqlserver.Smo)

    How to resolve this issue..

    Wednesday, January 15, 2014 5:34 AM

Answers

  • you cannot restore from higher to lower version.but you can try with the scripting out all objects from 2008 R2 for your database and recreate on the 2008.

    refer below article for different SQL Server versions & builds

    http://sqlserverbuilds.blogspot.in/


    Please mark solved if I've answered your question, vote for it as helpful to help other users find a solution quicker
    Praveen Dsa | MCITP - Database Administrator 2008 | My Blog | My Page



    Wednesday, January 15, 2014 5:47 AM