What are the challenges you face when working across database platforms? Take the survey

Restore error after conversion from sqb to bak

PowerwayPowerway Posts: 29
edited June 22, 2007 1:04PM in SQL Backup Previous Versions
We used the SQLBackupC command to extract the bak files out of a sqb.

When we attempted to restore these files, we got this. Any ideas?

Restore failed for Server 'dev-strsdb1'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName ... nkId=20476


System.Data.SqlClient.SqlError: The media family on device 'J:\Prod Backups\FULL_(local)_v3-Production_20070610_062116_01.bak' is incorrectly formed. SQL Server cannot process this media family. (Microsoft.SqlServer.Smo)


  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1

    I think you had possibly used sqb2mtf.exe to convert the backup file to native SQL Server format rather than SQLBackupc, which is the command-line version of SQL Backup. Is this correct? Or did you use the CONVERT command from SQLBackupC?

    At any rate I think this could be down to a problem with the version of SQB2MTF that came in SQL Backup 5.0, which was later fixed in 5.1. You may want to consider upgrading, or use the extended stored procedure of SQL Backup from Query Analyzer or Management Studio to convert the file using the CONVERT command:
    exec master..sqlbackup '-SQL "CONVERT [x.sqb] TO [x.BAK] WITH PASSWORD=xxxx"'

    Possibly after converting the backup file with the extended stored procedure the conversion will work properly.

Sign In or Register to comment.