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, 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=’

‘ /> .So i cant take backup now . By now, i am gettin error in both source and destination. There is anythin special about SQL7.00, Please advice

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. I still dont know what was that issue, today i took a backup/ restored in test, without any issuse, but using our favourite QA <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> . thanks to god, and all the members here .

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.

]]>