Restoring A SQL Server db

[mred2nice]

Good Afternoon

Shopping for some help restoring a SQL Server database. I am getting the following error message:

The media set for database 'IQS'has 2 family members, but only one are provided. All members must be provided.

Can anyone help me understand what the message is telling me?

Thanks for the help,
Ed Dobias

[MAK]

It means when backup tookplace it was striped into two or three different files (same or different location).

you can restore it specifying all the backup file names


restore database pubs from
disk = 'F:\Program Files\Microsoft SQL Server\MSSQL$INSTANCE1\BACKUP\dump1.BAK',
disk = 'F:\Program Files\Microsoft SQL Server\MSSQL$INSTANCE1\BACKUP\dump2.BAK'
with replace

[mred2nice]

Thank you for responding...that was a big help. This is new to me. In the past I have just selected restore database and then picked the IQS110303 backup file on the server. If you could stay with me on this, I am still having a little trouble. In order to find all the backup filenames like you showed, in Query analyzer I executed:

restore filelistonly from disk = 'G:\MECHSVRBKUP\IQS110303'

That gave me 3 files:
C:\MSSQL7\Data\IQS\iqsdata12.mdf
c:\mssql7data\iqs\iqsdata21.ndfiqslog1
c:\mssql7\data\iqs\iqslog1.ldf

So does the file I selected('G:\MECHSVRBKUP\IQS110303') just have the roadmap on where to get the restore data from?

OK, now I have the following statment prepared using your guidelines:

restore database IQS from
disk='C:\MSSQL7\Data\IQS\iqsdata12.mdf',
disk='c:\mssql7\data\iqs\iqsdata21.ndf',
disk='c:\mssql7\data\iqs\iqslog1.ldf' with replace

Where do I execute thie from?

Thanks again for the help,
Ed Dobias

[MAK]

NoNoNo


you can restore a backup not the .mdf , .ndf and ,ldf.

when you restore a backup it creates all the above files.

[mred2nice]

OK...understand that now. So the IQS110303 file I saved the backup to must be the .bak file?

Here is what I have now:
-right click on datbases in SQL
-restore database
-select from device option group
-hit select device and add IQS110303
-hit ok

Get the "media set for database 'IQS'has 2 family members, but only one are provided. All members must be provided." error. When you said striped to diff location, did you mean there is another .bak file somewhere on the server that was created when I did the backup?

Thanks,
Ed

[MAK]

YES