SQL Server Performance Forum – Threads Archive
ERROR: ODBC SQLState: 42000 -While restore
I took a back of my Production database in server1 (SQL 7.00)and
tried to restore in Test, server2 (SQL 7.00) ,I am getting following error . Microsoft SQL-DMO (ODBC SQLState:42000)
The media set for database ‘MYDB’ has 2 family members but only 1 are provided. All members must be provided.
I have only single backup file from production, but still gettin this error .Can anyone had same issue ? **I have a doubt if its anythin due to RAID imple.I am not sure even, how to check it, can any one advice me on this . Thanks in advance
Hello,<br /><br />I tried this once again, This time I am gettin same error in production server (server1) , while taking backup <img src=’/community/emoticons/emotion-6.gif’ alt=’
![Frown :( :(](styles/default/xenforo/smilies/frown.png)
Run
RESTORE FILELISTONLY dbname
for more information. 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.
I ran following in test server, on the backup taken from Production RESTORE FILELISTONLY from Disk="path to backup taken from prod" and found backup file has one *Datafile and *one logfile .
Hi all.<br /><br />I still dont know what was that issue, <br /><br />today i took a backup/ restored in test, without any issuse, but using our favourite QA <img src=’/community/emoticons/emotion-1.gif’ alt=’
![Smile :) :)](styles/default/xenforo/smilies/smile.png)
Hi All,
We took backup of a Database using SQLServer Enterprise Manager (SQLServer 2000)(given single path), on restoring it back using SQLServer Enterprise Manager we get an error message "The media set for database ” has 2 family members but only 1 are provided. All members must be provided. RESTORE DATABASE is terminating abnormally." In isqlw, I executed the command —
RESTORE FILELISTONLY from disk=’C:XXX’ –with the Backup DB file
I get the list of filegroupname that is part of our Database, but I couldn’t restore it. Could somebody help me to resolve this issue? Thanks in advance. Best Regards,
Jai
E-mail: [email protected] Jai
Yes the error is self-explanatory, refer to the books online about using RESTORE statement. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
]]>