1

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 ??

StanleyJohns
  • 5,982
  • 2
  • 25
  • 44
user2404431
  • 117
  • 2

1 Answers1

0

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.

Mark Kram
  • 101
  • 2