Backup failuer with error 3132.

  • shotman

    Right there with Babe

    Points: 769

    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.

  • Ray Mond

    SSCertifiable

    Points: 7099

    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.

  • shotman

    Right there with Babe

    Points: 769

    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.

  • Ray Mond

    SSCertifiable

    Points: 7099

    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.

  • Michele Wu

    SSC Enthusiast

    Points: 102

    Thanks. It helps me to resolve my issue soon.

  • dineshvishe3

    SSC-Addicted

    Points: 464

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

    Any suggestion.

  • dineshvishe3

    SSC-Addicted

    Points: 464

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

    checj and confirm.

  • akg.vimal

    SSC Journeyman

    Points: 82

    Hope below article will solve your problem:

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

  • v.hashemzadeh

    Grasshopper

    Points: 15

    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