Unable to restore DB Backup from SQL 2008 R2 to SQL 2005- “RESTORE HEADERONLY is terminating”

If you have taken a backup from higher SQL version and tried to restore that DB to a lower version SQL server you will see such error. Well, the true fact is, it is impossible to restore higher version DB on lower SQL Version.

Solution

The only solution what I successfully tested is –

  • Create an empty Database in your lower version SQL Server
  • Right click on that newly created DB and click on Tasks –> Import Data
  • Choose the Source server and DB
  • Select the Tables you want to import

Leave a comment