Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

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

I have SQL Server 2008 and I want to restore a database from SQL Server 2008 R2. When I try to restore, SQL Server produces an error message that the database came from a newer version of SQL Server than the one I have.

share|improve this question
possible duplicate of Restoring a backup to an older version of SQL Server and several others – gbn Sep 18 '11 at 10:57
up vote 4 down vote accepted

Sorry, but backup and restore won't allow you to restore that way - you can only restore to a higher version (backwards compatibility) rather than a lower version (forwards compatibility?). You'll need to export and import the data, or use scripts, or some other way of transferring everything.

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.