Restore Problem

Hi everyone. I am trying to restore a database and continue to get this
error message. Can anyone help?
The backup works fine. The back is from a primary server and the restore is
on the secondary. I wish to restore in standby.
Here is the code and the error msg. any help is appricated.
RESTORE DATABASE HSP_FMH
FROM DISK='\\Dbprod01\BACKUP\HSP_FMH\HSP_FMH.Backup.Device.BAK'
WITH
MOVE 'HSP_FMH_Data' TO 'G:\Program Files\Microsoft SQL
Server\MSSQL\Data\HSP_FMH_Data.MDF',
MOVE 'HSP_FMH_Log' TO 'G:\Program Files\Microsoft SQL
Server\MSSQL\Data\HSP_FMH_log.LDF',
STANDBY='\\Recover01\LogShipping\DBPROD0
2\UndoTransactionLog\HSP_FMH_UNDO.DA
T'
[Microsoft][ODBC SQL Server Driver]Unspecified error occurred on SQL
Server.
Connection may have been terminated by the server.
Server: Msg 3204, Level 16, State 1, Line 1
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Connection BrokenHi
Check the SQL Event Log for any events at the time. SQL Server might be
terminating the SPID due to a corrupt backup or other internal error.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Tom" <tbrackney@.kc.rr.com> wrote in message
news:amKWd.1085$Zm4.566@.twister.rdc-kc.rr.com...
> Hi everyone. I am trying to restore a database and continue to get this
> error message. Can anyone help?
> The backup works fine. The back is from a primary server and the restore
is
> on the secondary. I wish to restore in standby.
> Here is the code and the error msg. any help is appricated.
> RESTORE DATABASE HSP_FMH
> FROM DISK='\\Dbprod01\BACKUP\HSP_FMH\HSP_FMH.Backup.Device.BAK'
> WITH
> MOVE 'HSP_FMH_Data' TO 'G:\Program Files\Microsoft SQL
> Server\MSSQL\Data\HSP_FMH_Data.MDF',
> MOVE 'HSP_FMH_Log' TO 'G:\Program Files\Microsoft SQL
> Server\MSSQL\Data\HSP_FMH_log.LDF',
>
STANDBY='\\Recover01\LogShipping\DBPROD0
2\UndoTransactionLog\HSP_FMH_UNDO.DA
T'
> [Microsoft][ODBC SQL Server Driver]Unspecified error occurred on SQL[/vbco
l]
Server.[vbcol=seagreen]
> Connection may have been terminated by the server.
> Server: Msg 3204, Level 16, State 1, Line 1
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> Connection Broken
>|||Well, I did that and it is not givning me any information. I have tried this
several times witht he same result. Any other ideas? Anyonw else have an
idea?
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:ehlM$RpIFHA.1096@.tk2msftngp13.phx.gbl...
> Hi
> Check the SQL Event Log for any events at the time. SQL Server might be
> terminating the SPID due to a corrupt backup or other internal error.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Tom" <tbrackney@.kc.rr.com> wrote in message
> news:amKWd.1085$Zm4.566@.twister.rdc-kc.rr.com...
> is
> STANDBY='\\Recover01\LogShipping\DBPROD0
2\UndoTransactionLog\HSP_FMH_UNDO.
DA
> T'
> Server.
>|||Yes. We've come across this several times. It has to do with slow disks
and network latency mixed with the use of UNC path network shares.
Normally, we only have trouble with the create files. So, we create our
backups locally and then use UNC to "PULL" the backup to the restore
location, just as you are currently doing.
However, I suspect that it is the creation of your UNDO.DAT file for the
Standby option. I would also use a local drive for that file, say the local
MSSQL\JOBS folder.
Go ahead and use the UNC to locate the backup file, but your MOVE commands,
and UNDO files should be local drive letters.
Good luck. Let us know how it works.
Sincerely,
Anthony Thomas
"Tom" <tbrackney@.kc.rr.com> wrote in message
news:a_KWd.18954$3V3.14955@.twister.rdc-kc.rr.com...
Well, I did that and it is not givning me any information. I have tried this
several times witht he same result. Any other ideas? Anyonw else have an
idea?
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:ehlM$RpIFHA.1096@.tk2msftngp13.phx.gbl...
> Hi
> Check the SQL Event Log for any events at the time. SQL Server might be
> terminating the SPID due to a corrupt backup or other internal error.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Tom" <tbrackney@.kc.rr.com> wrote in message
> news:amKWd.1085$Zm4.566@.twister.rdc-kc.rr.com...
> is
>
STANDBY='\\Recover01\LogShipping\DBPROD0
2\UndoTransactionLog\HSP_FMH_UNDO.DA
> T'
> Server.
>