Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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