Restore Database

When I try to restore my database receive the message:

"The media set for database 'MyDB' has 2 family members, but only 1 are provided. All members must be provided."

I don't find the other dump device.

Do I can restore anyway??

thanks,

Ericson.I am having a similar problem with a backup of a database that has been successfully running the past two months. Suddenly this weekend, the same error message started appearing for me?

Any ideas?|||Originally posted by acg_ray
I am having a similar problem with a backup of a database that has been successfully running the past two months. Suddenly this weekend, the same error message started appearing for me?

Any ideas?

I have no succes to restore my database.
I has create the database again e loses the data.|||One of my customers reported the same problem that you guys were having. I found in his case that he had spanned his backup across multiple files when he made it.

So, in the Database Backup Destination box, he had multiple entries before backing up. Then when he went to restore the database to another machine, he was unaware that he should have had multiple files. This restore file was coded to tell Sql Server that it was only one part of the backup.

In his case, I had him go back to the server and create only one backup file.|||Are you using tape backup? It may be that your database backup run across two tapes and it's looking for another backup media.

Restore backup error "Media family incorrectly formatted"

I am trying to restore backup from database1 with move to database2.
RESTORE DATABASE Database2
FROM DISK = '\\uncpath\database1.BAK'
WITH MOVE '_Data' TO 'LocalPath\database2.MDF'
, MOVE '_Log' TO 'LocalPath\database2.LDF'
, REPLACE
, DBO_ONLY
, NORECOVERY
I am getting the error:
Server: Msg 3241, Level 16, State 37, Line 7
The media family on device '\\uncpath\database1.BAK' is incorrectly
formed. SQL Server cannot process this media family.
Server: Msg 3013, Level 16, State 1, Line 7
RESTORE DATABASE is terminating abnormally.
After this backup was created to a UNC share, the file is backed up to
tape. We restored the file from tape and then get the problems above.
Any help will be greatly appreciated.
KalvinKalvin wrote:
> I am trying to restore backup from database1 with move to database2.
> RESTORE DATABASE Database2
> FROM DISK = '\\uncpath\database1.BAK'
> WITH MOVE '_Data' TO 'LocalPath\database2.MDF'
> , MOVE '_Log' TO 'LocalPath\database2.LDF'
> , REPLACE
> , DBO_ONLY
> , NORECOVERY
> I am getting the error:
> Server: Msg 3241, Level 16, State 37, Line 7
> The media family on device '\\uncpath\database1.BAK' is incorrectly
> formed. SQL Server cannot process this media family.
> Server: Msg 3013, Level 16, State 1, Line 7
> RESTORE DATABASE is terminating abnormally.
> After this backup was created to a UNC share, the file is backed up to
> tape. We restored the file from tape and then get the problems above.
> Any help will be greatly appreciated.
> Kalvin
Have you tried not moving the log file? See this page for information
that may help:
http://support.microsoft.com/defaul...kb;en-us;272093
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Thank you for your reply.
I can't restore it over the current production database. The production
database is working fine, but there is some data from a couple months
ago that was deleted and I need to retrieve only that portion of data.
Is there another way to restore a backup from DB1 to DB2 without doing a
with move?
Kalvin
*** Sent via Developersdex http://www.examnotes.net ***|||Kalvin wrote:
> I am trying to restore backup from database1 with move to database2.
> RESTORE DATABASE Database2
> FROM DISK = '\\uncpath\database1.BAK'
> WITH MOVE '_Data' TO 'LocalPath\database2.MDF'
> , MOVE '_Log' TO 'LocalPath\database2.LDF'
> , REPLACE
> , DBO_ONLY
> , NORECOVERY
> I am getting the error:
> Server: Msg 3241, Level 16, State 37, Line 7
> The media family on device '\\uncpath\database1.BAK' is incorrectly
> formed. SQL Server cannot process this media family.
> Server: Msg 3013, Level 16, State 1, Line 7
> RESTORE DATABASE is terminating abnormally.
> After this backup was created to a UNC share, the file is backed up to
> tape. We restored the file from tape and then get the problems above.
> Any help will be greatly appreciated.
> Kalvin
Also check this:
http://support.microsoft.com/defaul...b;EN-US;Q221465
David Gugick
Quest Software
www.imceda.com
www.quest.com