Unable to restore User database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Farhan (Farhan_at_discussions.microsoft.com)
Date: 02/28/05 

Date: Mon, 28 Feb 2005 02:27:05 -0800

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

Relevant Pages

  • Re: DUMP DATABASE
    ... database to a new server. ... Backup and Restore database ... copy the mdf and ldf to second server ...
    (microsoft.public.sqlserver.programming)
  • Re: copy database via tapefile no SQL 2005
    ... I choose Restore Database From Device then I ... Microsoft SQL Server Management Studio ...
    (comp.databases.ms-sqlserver)
  • Re: copy database via tapefile no SQL 2005
    ... I choose Restore Database From Device then I ... Microsoft SQL Server Management Studio ...
    (comp.databases.ms-sqlserver)
  • SQL doesnt exist or access denied
    ... RESTORE DATABASE DB_2 ... files DB_2.mdf and DB_2.ldf on another server msde then I used ... "System.Data.SqlClient.SqlException: ... I don't know if it's SQL problem or if it's .NET application problem ...
    (microsoft.public.sqlserver.server)