I am having a database backup file from SQL SERVER 2012 and i wanted to restore it on SQL SERVER 2008R2 . If we can’t restore a SQL Server 2012 database to earlier version what is the next best option? So Is their any way to restore by any other way ??

  • 1
    You can't restore from a newer version of SQL to an older version. You will have to export your tables and import them into the older sql server. May 27, 2013 at 18:21

1 Answer 1


The only way this would be possible would be to restore the Back up to a SQL 2012 instance and then try importing it to a SQL 2008-R2 instance. You may have to create some sort of ETL script to do the importing.

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