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