SQL Server Performance Forum – Threads Archive
Restore Database Terminating
Hi Guys,I’m trying to restore a database copy in my environment.
It gives an error: The media set for database ‘devdaily’ has 2 family members but only 1 are provided. All members must be provided.
RESTORE DATABSE is terminating abnormally. What is going wrong here [xx(]
Run RESTORE FILELISTONLY to see the files during backup. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Your back up spanned two tapes (or other media). You need both to restore the data.
This was discussed in
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=10477 —————————————-
Cast your vote
http://www.geocities.com/dineshasanka/sqlserver05.html http://spaces.msn.com/members/dineshasanka
Hi,
I’m using EM to restore the backup.
It is just one file.
What is the syntax example to use as BOL is mentioning many parameters.
The backup i took on USB HDD and copied to server’s local HDD and now that USB disk is not connected.
Is it something to do with that.
Please give some example to use restore options as i’m not used to this.
I’m using EM but with ur help can swith to QA.
hi, i ran this
RESTORE filelistonly
from disk=’f:dev3_daily’
and gives resultset with two rows. one mdf and one ldf file details.
What next guys.
How to use restore with replace statement.
Try
RESTORE DATABASE [DBName ] FROM DISK = N’\servernamepathdbname.BAK’ WITH FILE = 1, NOUNLOAD ,
STATS = 10, RECOVERY , REPLACE , MOVE N’DB_Datafile_Data’ TO N’\servernamepathdbname_data.NDF’
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Hi, EXEC sp_addumpdevice ‘disk’, ‘mydiskdump’, ‘f:dev3_daily’ RESTORE DATABASE yourdb
FROM Mydiskdump
replace Or RESTORE DATABASE yourDB
FROM DISK = ‘f:dev3_daily’
WITH MOVE ‘yrdb’ TO ‘x:databasesyrdbnameyrdb.mdf’,
MOVE ‘yrdb_log’ TO ‘x:databasesyrdbnameyrdb.ldf’
Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami
Hi Satya & Hemant,
I tried both solutions but still gives that same error.
Hi,
would you post the error message ! Regards
Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami
If you’re having problems because you believe the drive is different, use subst to allow the local disk to be called using a different drive letter. I.e. you have local disks C and D, and backed up to a removable disk E. You have copied the backup file to D. 1 subst E: D:
2 do your work 3 subst E: /D
quote:Originally posted by ghemant
Hi,
would you post the error message ! Regards
Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami
would you post the error message ! Regards
Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami
Hi Hemant I’ve posted the error in my first post. The media set for database ‘devdaily’ has 2 family members but only 1 are provided. All members must be provided.
RESTORE DATABSE is terminating abnormally
and ill try mulhall ur advice.
Hi,
when i run
RESTORE filelistonly
from disk=’f:dev3_daily’
i get LogicalName PhysicalName Type FileGroupName Size MaxSize
uat_nv_daily d
rogram FilesCompuwareNetworkVantageDatadev3_nv_daily.mdf D PRIMARY 37435408384 35184372080640uat_nv_daily_LOG d
rogram FilesCompuwareNetworkVantageDatadev3_nv_daily_log.ldf L NULL 858587136 35184372080640
(2 row(s) affected)
and when i run
RESTORE labelonlyfrom disk=’f:dev3_daily’
i get this output.
MediaName MediaSetId FamilyCount FamilySequenceNumber MediaFamilyId MediaSequenceNumber MediaLabelPresent MediaDescriptionSoftwareVendorId MediaDate
NULL {C477099A-7619-4E72-8D1E-7E3A14E0DAE5} 2 2 {390AF160-0000-0000-0000-000000000000} 1 0 NULL Microsoft SQL Server 4608 2005-09-16 09:48:15.000
(1 row(s) affected) After this when i run restore database dev3_nv_daily
from disk=’f:dev3_daily’
WITH
FILE = 1, NOUNLOAD , STATS = 10, RECOVERY, replace ,
move N’uat_nv_daily’ TO N’f:dev3_nv_dailydev3_nv_daily.ndf’ — , move N’uat_nv_daily_LOG’ TO N’f:dev3_nv_dailydev3_nv_daily_log.ldf’
go
i get the error.
The media set for database ‘devdaily’ has 2 family members but only 1 are provided. All members must be provided.
RESTORE DATABSE is terminating abnormally.
Any comments guys on this …
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by ranjitjain</i><br /><br />Hi,<br />when i run <br />RESTORE filelistonly<br />from disk=’f:dev3_daily'<br />i get <br /><br />LogicalName PhysicalName Type FileGroupName Size MaxSize <br />uat_nv_daily d
rogram FilesCompuwareNetworkVantageDatadev3_nv_daily.mdf D PRIMARY 37435408384 35184372080640<br />uat_nv_daily_LOG drogram FilesCompuwareNetworkVantageDatadev3_nv_daily_log.ldf L NULL 858587136 35184372080640<br /><br />(2 row(s) affected)<br /><br />and when i run<br /><br />RESTORE labelonly<br />from disk=’f:dev3_daily'<br />i get this output.<br />MediaName MediaSetId FamilyCount FamilySequenceNumber MediaFamilyId MediaSequenceNumber MediaLabelPresent MediaDescriptionSoftwareVendorId MediaDate<br />NULL {C477099A-7619-4E72-8D1E-7E3A14E0DAE5} 2 2 {390AF160-0000-0000-0000-000000000000} 1 0 NULL Microsoft SQL Server 4608 2005-09-16 09:48:15.000<br />(1 row(s) affected)<br /><br />After this when i run<br /><br />restore database dev3_nv_daily<br />from disk=’f:dev3_daily'<br /> WITH <br />FILE = 1, NOUNLOAD , STATS = 10, RECOVERY, replace ,<br />move N’uat_nv_daily’ TO N’f:dev3_nv_dailydev3_nv_daily.ndf’ — , move N’uat_nv_daily_LOG’ TO N’f:dev3_nv_dailydev3_nv_daily_log.ldf’ <br />go<br />i get the error. <br />The media set for database ‘devdaily’ has 2 family members but only 1 are provided. All members must be provided.<br />RESTORE DATABSE is terminating abnormally.<br />Any comments guys on this …<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br /><br />Hi,<br />would you run <br />RESTORE VERIFYONLY <br />FROM yourdisk , and if i understood yr backup contains two backup and then you have to give medianame tooo in order to restore it.<br /><br />MEDIANAME = yourmedianame<br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />]<br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami<br />
Hi,
I got a similar error and was able to solve it. I have compiled the main points of the solution here-
http://manojagarwal.livejournal.com/2007/10/16/
]]>