Backup failuer with error 3132.

Question

Backup failuer with error 3132.

shotman

Right there with Babe

Points: 769
More actions
December 7, 2010 at 11:30 am

#243610

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.
August 19, 2018 at 11:24 pm

This was removed by the editor as SPAM

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

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

Ray Mond SSCertifiable Points: 7159 More actions · Answer 1

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 More actions · Answer 2

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: 7159 More actions · Answer 3

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 More actions · Answer 4

Michele Wu

SSC Enthusiast

Points: 102

October 3, 2013 at 1:59 pm

#1655683

Thanks. It helps me to resolve my issue soon.

dineshvishe3 SSC-Addicted Points: 464 More actions · Answer 5

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

Any suggestion.

dineshvishe3 SSC-Addicted Points: 464 More actions · Answer 6

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

checj and confirm.

akg.vimal SSC Journeyman Points: 84 More actions · Answer 7

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 More actions · Answer 8

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 ?