Hi, I am trying to restore on backup file from one of the servers to other local, but I am getting error of "RESTORE HEADERONLY is Terminating Abnormally (Microsoft SQL Server Error:3013)". Please let me know what can I do to make the restore. As this backup file is working fine on one of the other servers absolutly fine.
Could be a corrupt backup file, could be the wrong version of SQL Server... Are you attempting to restore to the same version (or later) of SQL? ie the backup was taken on a 2008r2 box and is being restored to the same? Or is it a 2008r2 backup that you're attempting to restore to a 2005 server?