Red Gate forums :: View topic - Mediaset families missing after conversion from SQB
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 6
SQL Backup 6 forum

Mediaset families missing after conversion from SQB

Search in SQL Backup 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
reinisb



Joined: 05 Jul 2012
Posts: 13

PostPosted: Fri Mar 15, 2013 5:47 pm    Post subject: Mediaset families missing after conversion from SQB Reply with quote

Hi,

I have an SQB backup that I converted back to a .BAK so I could restore through the SQL Server native GUI.

During the conversion the SQB was extracted to 23 seperate BAK files. If I understand correctly, this is because the THREADCOUNT parameter in the SQL Backup command is 23.

However, when I select all the backup files in the SQL Server GUI, set the file locations, etc. and try to execute the backup, SQL Server gives me the following error:

Restore failed for Server 'LAXNODE\LAXInstance'. (Microsoft.SqlServer.SmoExtended)

............................

The media set has 23 media families but only 1 are provided. All members must be provided.
RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3132)


Looking online that error usually means you created a backup using two different files in the first place, so my guess is that because of the threadcount parameter SQL Backup creates it with 23 different backup files initially before it compresses it into a single SQB.

How do I get this backup to restore correctly? I have selected all the files available, so I would think it would work.

Does anyone have any solutions?

Thanks,

Reinis
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2306

PostPosted: Sat Mar 16, 2013 8:23 am    Post subject: Reply with quote

If use SQL Profiler to trace the restore command that SQL Server is using, is it trying to restore using all 23 bak files, or only a single bak file?
_________________
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
Back to top
View user's profile Send private message Send e-mail
reinisb



Joined: 05 Jul 2012
Posts: 13

PostPosted: Tue Mar 19, 2013 3:50 pm    Post subject: Reply with quote

Thanks Petey for the response.

I tried it again and it worked. It's possible I was being a doofus and trying to restore files and filegroups instead of database (it was friday afternoon after all Rolling Eyes ), but I'm not sure.

I will go to Profiler quicker next time!

Thanks.

Reinis
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group