SQL Server 2000 Database Restore Issues -- sql server new users

paul2010
1/22/2005 1:31:06 PM

Hi,

I am trying to restore a SQL Server 2000 database that is backeup up on a
different machine. I am getting the following error while restoring:

ODBC SQLState: 42000
The media set for database 'xxxxxx' has 2 family members but only 1 are
provided. All members must be provided. RESTORE DATABASE is terminating
abnormally.

The user who is performing the backup has SQL Server installed on C:\ and
data and log files on D:\ drives, whereas I have both SQL database and its
data and log files directories on the C:\ drive.....is this the problem?

We have also made sure the the user is logged on as admin and using Windows
Authentication.

In the Restore Database Options window, we can see two family members under
Logical Files and Physical File Locations, then why are we getting the error
for only 1 member is provided?

We have tried several combinations of restore......but same results.....NEED
HELP!

Thanks,

Paul

Jose Molina
1/24/2005 10:01:40 AM

Hi Paul,
Typically this means that your backup was done using more than one device or
backup file and you are trying to restore using just one of them. Make sure
you provide all of the backup devices in your restore command, e.g:

RESTORE DATABASE YourDatabase
FROM
DISK = 'C:\YourDB1.BAK', DISK = 'C:\YourDB2.BAK'

Also take a look at RESTORE LABLEONLY in BOL as this can give you
information on the backup media.

RESTORE LABELONLY
FROM DISK='C:\Backups\MyBackup.bak'

If the FamilyCount is >1 then you need the remaining files to perform the
restore.

Hope this helps!

Regards,
-Jose Molina

[quoted text, click to view]

sql server new users : SQL Server 2000 Database Restore Issues