May 18, 2009 at 8:30 am
Hi,
I got the below error message
The media set has 3 media families but only 1 are provided. All members must be provided.
when i tried to execute the below command.
RESTORE FILELISTONLY FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL\Backup\SDMS_OLAP.bak'
LogicalName:
SDMS_OLAP
SDMS_OLAP_log
--------------------------------------------------------------------------------------
RESTORE DATABASE SDMS_OLAP
FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL\Backup\SDMS_OLAP.bak'
WITH REPLACE, MOVE 'SDMS_OLAP' TO 'D:\sdms_demo_testing_db_bkup\SDMS_OLAP.mdf',
MOVE 'SDMS_OLAP_log' TO 'D:\sdms_demo_testing_db_bkup\SDMS_OLAP_log.ldf'
Msg 3132, Level 16, State 1, Line 1
The media set has 3 media families but only 1 are provided. All members must be provided.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Inputs are welcome!
karthik
May 18, 2009 at 8:52 am
It seems that you performed the backup to 3 devices in place of 1.... U have to specify all them
RESTORE DATABASE AdventureWorks FROM DISK = 'c:\..\backupset1.bak', DISK = 'c:\..\backupset2.bak', DISK= 'c:\..\backupset3.bak'
May 18, 2009 at 9:26 am
I got this backup file from (SDMS_OLAP.bak) some one of my team person.
There is no option to create one more backup as the server is not available now.
Using this only backup file how can i restore.
Atleast i need to get table structure from this backup file.
Kindly let me know the way.
karthik
May 18, 2009 at 10:20 am
karthikeyan (5/18/2009)
Using this only backup file how can i restore.
You can't.
You have one piece of a backup. If three backup destinations are specified (either in script or in the backup database dialog), SQL stripes the backup across all three evenly. Without all three, you cannot restore that database. There's no way around that.
If you want to restore that, you have to find the other two pieces of the backup.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply