1

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?

Improve this question
2
  • Can you upgrade your development server to SQL Server 2008 R2? Commented Nov 26, 2011 at 13:40
  • no, i can't.... Commented Nov 26, 2011 at 13:45

1 Answer 1

Reset to default
1

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

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.