The media family on device 'D:\Web_Applications_Sabin\HOF\LPT\HOF_NEW_BACKUP.bak' is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)
I was trying to restore a database back up on my machine. Back up file was taken from a different machine. Got stuck up with the error.
Later I realised, it was due to the compatibility issue as the Back up was taken from SQL Server 2008 Express and I was restoring on SQL Server 2005 Express.
Resolution.
Generate Script (.sql) from the destination server and execute in the source server.
