February 7, 2007 at 11:25 am
I did a full DB backup that I am trying now to restore via the SQL Server Management Studio.
I select Restore and then From Device and point to the bak file that I want to restore from.
I then go into the Options page and check overwrite the existing database.
Below that, shows the Restore the database files as
RB_Data_Services_MSCRM
RB_Data_Services_MSCRM_Log
sysft_ftcat_documentindex
When I then click OK I get the following error. The Media Set has 3 Media Families but only 1 are provided. All members must be provided.
Any ideas as to what I did to do to be able to complete this restore?
Thanks.
Rick Bellefond
February 7, 2007 at 12:01 pm
When you did a backup, there probably were files in the list of "Backup To.." on the General tab. These file names are there by default from the pervious backup. You have to remove them before adding your backup file name. If you don't do that your backup is distributed between all files in the list.
Regards,Yelena Varsha
February 7, 2007 at 1:36 pm
Oh, that does not sound good. So while I thought that I was making a backup to a single file I actually made it to multiple files. The only backup file that I have is that one bak file. So I guess that means that I just can't restore. Yuck.
Thanks.
Rick Bellefond
February 7, 2007 at 2:15 pm
You can find the backup files location from system tables...
Check the following script which works in 2000 but I have not tested in 2005...
select
database_name as 'Database_Name' ,
(b. physical_device_name) as 'Backup_Location' ,
backup_start_date,
backup_finish_date
FROM msdb.dbo.backupset a
join msdb.dbo.backupmediafamily b on a.media_set_id = b.media_set_id
join msdb.dbo.backupfile c on a.backup_set_id = c.backup_set_id
where backup_start_date = (SELECT MAX(backup_start_date)
FROM msdb.dbo.backupset
WHERE database_name = a.database_name
AND type = 'D') -- full database backups only, not log backups
and type = 'd' and server_name = @@servername
and c.file_type = 'd' -- and c.physical_name like '%.mdf'
and database_name = '<db name>'
group by database_name, backup_finish_date, backup_start_date,b.physical_device_name
MohammedU
Microsoft SQL Server MVP
February 7, 2007 at 3:06 pm
This is a very good script, Mohammed!
I tested it on SQL Server 2005, it works.
Rick,
you should run this script on the server where you did a backup and in the script replace <db name> with your database name.
Regards,Yelena Varsha
February 7, 2007 at 3:51 pm
Mohammed and Yelena,
You guys are amazing.
Thanks.
Rick Bellefond
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply