Backup failuer with error 3132.

  • has anyone come across this error and any solution :

    Msg 3132, Level 16, State 1, Line 1

    The media set has 2 media families but only 1 are provided. All members must be provided.

    Msg 3013, Level 16, State 1, Line 1

    BACKUP DATABASE is terminating abnormally.

    MSFT has a hot fix but not sure if that's the only fix to above issue.

  • Are you backing up to an existing file? That's probably the case, and the existing file contains a backup set that was split across 2 files. If you want to append to the existing file, you would need to also split your backup across the same 2 files.

    SQL BAK Explorer - read SQL Server backup file details without SQL Server.
    Supports backup files created with SQL Server 2005 up to SQL Server 2017.

  • We take full backup of the db's daily and all of a sudden we start seeing this error for last 3 days for one particular db. Nothing has changed and there are other db's that are working fine.

  • We take full backup of the db's daily and all of a sudden we start seeing this error for last 3 days for one particular db. Nothing has changed and there are other db's that are working fine.

    That does not answer the questions I posed.

    Try running RESTORE LABELONLY using the file name you are trying to back up to, e.g.

    RESTORE LABELONLY FROM DISK = '<your file name>'

    Firstly, does the file already exist? If it does, how many rows are returned, and what is the FamilyCount value? You can then find out the names of the files in that existing backup set using the following:

    SELECT b.physical_device_name

    FROM msdb..backupmediaset a

    INNER JOIN msdb..backupmediafamily b ON a.media_set_id = b.media_set_id

    WHERE a.media_uuid = '<the MediaSetID value found in the backup set label>'

    SQL BAK Explorer - read SQL Server backup file details without SQL Server.
    Supports backup files created with SQL Server 2005 up to SQL Server 2017.

  • Thanks. It helps me to resolve my issue soon.

  • I had verify ,label only ,headreronly .I an trying through gui,getting same error.

    Any suggestion.

  • restore verify from disk='path:', disk:'path2'

    checj and confirm.

  • Hope below article will solve your problem:

    http://accidentalsqldba.blogspot.in/2015/02/error-msg-3132-level-16-state-1-line-1.html

  • Ray Mond - Wednesday, December 8, 2010 7:36 PM

    We take full backup of the db's daily and all of a sudden we start seeing this error for last 3 days for one particular db. Nothing has changed and there are other db's that are working fine.

    That does not answer the questions I posed.Try running RESTORE LABELONLY using the file name you are trying to back up to, e.g.RESTORE LABELONLY FROM DISK = '<your file name>'Firstly, does the file already exist? If it does, how many rows are returned, and what is the FamilyCount value? You can then find out the names of the files in that existing backup set using the following:SELECT b.physical_device_nameFROM msdb..backupmediaset aINNER JOIN msdb..backupmediafamily b ON a.media_set_id = b.media_set_idWHERE a.media_uuid = '<the MediaSetID value found in the backup set label>'

    Hi
    I have a backup 
    I take full backup  , but  familyCount is 2
    can I update familyCount in label database  ? how ?

  • This was removed by the editor as SPAM

Viewing 10 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply