Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.... –  itgeek Nov 26 '11 at 13:45
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.