SQLTeam.com | Weblogs | Forums

Unable to restore sql bak file to database

Using sql 2008 r2 std edition with sp3. we had issue with our server, had to recover all files , after we lost them a month ago, it found 300 backup files, using gteh latest bak file, tried to trestore getting the below error. is there a repair tool for backup file to fix if bak up file is corrupted?
thanks a lot for the helpful info.

Msg 3241, Level 16, State 0, Line 2
The media family on device 'C:\netorddb\netord_backup.bak' is incorrectly formed. SQL Server cannot process this media family.
Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.

Where was the .bak stored at and how did you get it over to the sql server?
Did you copy it to your server and trying to restore it there? Or are you restoring from another network location?

You can use a third-party utility like SQL Backup Recovery Software from Databasefilerecovery. You can easily restore your Bak file using this exceptional tool. It is an efficient way to restore the SQL database from the bak file in all Windows editions.

1 Like

It looks as though the file is corrupted. Try one of the previous .bak files.