"The media family on device 'Foo.bak' is incorrectly formed." When restoring with SSMS
Should I be able to restore a MSP360 SQL backup using SSMS?
When I try to select the .bak file in the Restore Database dialog I get the following error:
The media family on device 'Foo.bak' is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)
The source SQL server instance version is 14.0.2027.2 on Windows Server 2019 Datacenter. The destination instance is version 14.0.2027.2 on Windows 10 Pro.
If you use MSP360 / CloudBerry Backup to back up the database, then you either need to use MSP360 Backup to perform the restore of the SQL Server database, or you need to use MSP360 Backup to restore the backup files to disk and then use Management Studio to perform the database restore. You cannot, as you've seen, simply restore from the backup files themselves as they are encrypted and in a proprietary MSP360 format. I hope that helps.
Sign in or register to add a comment.
Add a Comment
Welcome to MSP360 Forum!
MSP360 Managed Products
Managed Backup - General
Managed Backup Windows
Managed Backup Mac
Managed Backup Linux
Managed Backup SQL Server
Managed Backup Exchange
Managed Backup Microsoft 365
Managed Backup G Workspace
Backup for Linux
Backup SQL Server
Connect Free/Pro (Remote Desktop)
BitmapHeader Signatures not equal error restoring backup
Restoring Image to VMWare ESXi 6 fails
Backing up a VMware VM and restoring to Hyper-V or Azure
Restoring Image backup to Hyper-V won't boot
Terms of Service
Useful Hints and Tips
Created with PlushForums
© 2023 MSP360 Forum