Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Backup failuer with error 3132. Expand / Collapse
Author
Message
Posted Tuesday, December 7, 2010 11:30 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 12:48 PM
Points: 50, Visits: 71
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.

[url=http://support.microsoft.com/kb/921106 ][/url]



Post #1031419
Posted Wednesday, December 8, 2010 1:00 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, June 21, 2014 2:00 AM
Points: 343, Visits: 1,517
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.

Ray Mond
Yohz Software
Providing SQL Server database tools for 9 years and counting.
http://www.yohz.com
Post #1031683
Posted Wednesday, December 8, 2010 12:44 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 12:48 PM
Points: 50, Visits: 71
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.


Post #1032123
Posted Wednesday, December 8, 2010 7:36 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, June 21, 2014 2:00 AM
Points: 343, Visits: 1,517
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>'



Ray Mond
Yohz Software
Providing SQL Server database tools for 9 years and counting.
http://www.yohz.com
Post #1032257
Posted Thursday, October 3, 2013 1:59 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 2:29 PM
Points: 2, Visits: 302
Thanks. It helps me to resolve my issue soon.
Post #1501341
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse