SQL Server error 3132 "The media set has <x> media families" - SQL Storage Compress

You may encounter the following error when creating a compressed database by restoring from a SQL Backup Pro backup file (*.sqb):

Msg 3132, Level 16, State 1, Line 1

The media set has <x> media families but only <y> are provided. All members must be provided.

Resolving this error

This error arises when a SQL Backup Pro backup file has been created using more than one thread. The RESTORE command should include one DISK statment for each thread that was used to create the backup.

For example, if a SQL Backup Pro backup was created using three threads:

EXECUTE master..sqlbackup '-sql "BACKUP DATABASE AdventureWorks

TO DISK = ''C:\Backups\AdventureWorks_Full.sqb''

WITH COMPRESSION = 4, THREADCOUNT = 3"'

the RESTORE command should include three identical DISK statements:

RESTORE DATABASE AdventureWorks_SSC FROM

DISK = 'C:\Backups\AdventureWorks_Full.sqb'

DISK = 'C:\Backups\AdventureWorks_Full.sqb'

DISK = 'C:\Backups\AdventureWorks_Full.sqb'

WITH MOVE 'AdventureWorks_Data' TO 'C:\Program Files\MSSQL\DATA\AdventureWorks_SSC_Data.mdfx'

To find out how many threads were used to create a backup file, run RESTORE LABELONLY FROM DISK = '<backup_path>'. This command returns information about the backup file. The value for FamilyCount represents the number of threads used to create the backup file.

Alternatively, look at the BACKUP command in the SQL Backup Pro activity log file: the THREADCOUNT option specifies the number of threads used. You can view log files from the Activity History in the SQL Backup user interface or from the log folder, specified in the File Management Options.