Unable to restore User database from One Server to another server, when ever
I going to restore database it’s giving following error

Server: Msg 3132, Level 16, State 1, Line 1
The media set for database 'Vacancies' has 2 family members but only 1 are
provided. All members must be provided.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

I have same configuration and specification on both servers

Please help

Farhan Iqbal

The error means the backup was done using more than one
device or backup file and you are trying to restore using
just one. You need to provide all the backup devices, files
in your restore command, e.g.:
RESTORE DATABASE YourDB
FROM
DISK = 'C:\YourDB_1.BAK', DISK = 'C:\YourDB_2.BAK'

-Sue

On Mon, 28 Feb 2005 02:27:05 -0800, Farhan
<Farhan (AT) discussions (DOT) microsoft.com> wrote: