Backup file can’t be accessed

If you try to restore a database from a backup (using T-SQL, not the UI) and get the following error, this post may be for you.

The media family on device 'D:Test\Test.bak' is incorrectly formed. SQL Server cannot process this media family.

If you see this, check out the following possible solutions

  1. The backup is corrupted as it has not been transferred in binary mode If you are using FTP to transfer the backup, make sure the file is transferred in binary mode
  2. The version of your backup is different than the SQL Server instance you are trying to restore it to. You can try to restore to a SQL server instance with the right version and transfer the data with SSIS

I hope that helps. Also, obviously make sure the file path is correct!