June 12, 2013 at 10:26 am
I backed up a database via Red Gate and used the sqb2mtf to convert the backup to be recognized by SQL (.bak file). In doing so, this created 9 bak files. Now I am attempting to VERIFY the backups via TSQL and am not having any luck.
The command I am attempting to run is:
RESTORE VERIFYONLY
FROM DISK = 'F:\Temp\FULL_DbBackup_00.bak'
In doing so I get the following error:
Msg 3132, Level 16, State 1, Line 1
The media set has 9 media families but only 1 are provided. All members must be provided.
Msg 3013, Level 16, State 1, Line 1
VERIFY DATABASE is terminating abnormally.
I have been Googling this with no luck and am needing to verify all 9 of these bak files (00-08). I found that there is a WITH FILE = n switch that I can not get to work and I found where someone posted some syntax on using the backup command to split a backup into multiple files.
Can someone please advise on the easiest way to do this? Any and all help will be greatly appreciated!!
Thanks in Advance...
June 12, 2013 at 10:33 am
It sounds like the Red-Gate backup was created with multiple threads (therefore multiple files for the same backup).
Just need to list them all in the restore syntax:
RESTORE VERIFYONLY
FROM DISK = 'F:\Temp\FULL_DbBackup_00.bak',
DISK = 'F:\Temp\FULL_DbBackup_01.bak',
DISK = 'F:\Temp\FULL_DbBackup_02.bak',
DISK = 'F:\Temp\FULL_DbBackup_03.bak'
--etc.
June 12, 2013 at 10:38 am
Thank you so much Howard! I really appreciate it...
June 12, 2013 at 1:40 pm
The error is what it says, you are missing part of the media family. This is a striped backup, and you can do this natively in SQL Server.
In Backup Pro, when we use multiple threads, we are essentially streaming this backup to multiple files ,but we combine them together (short, non technical explanation). When you convert this to native format, each thread is separated out to its own file.
The verify (or restore) means that all files must be specified in the command, as Howard noted.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply