Well, I have accidently upgraded my production server from SQL Server 2008 to SQL Server 2008 R2. Now when I am restoring database from production to my development computer which have SQL Server 2008, it says Restore Failed because it is not possible to restore to old version.

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.

Now please let me know that can I revert back to my old SQL Server 2008? or what are other solution?

  • Can you upgrade your development server to SQL Server 2008 R2? – joeqwerty Nov 26 '11 at 13:40
  • no, i can't.... – Charandeep Singh Nov 26 '11 at 13:45

You can uninstall the wrong version and reinstall the correct one.

You can restore your server from backup.

You can put the database in compatibility mode for older versions of SQL server.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.