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.Dev ice.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\DBPROD02\UndoTran sactionLog\HSP_FMH_UNDO.DAT'
[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 Broken
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...
> 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.Dev ice.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\DBPROD02\UndoTran sactionLog\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 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\DBPROD02\UndoTran sactionLog\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\DBPROD02\UndoTran sactionLog\HSP_FMH_UNDO.DA
> T'
> Server.
>
Showing posts with label continue. Show all posts
Showing posts with label continue. Show all posts
Monday, March 12, 2012
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\DBPROD02\UndoTransactionLog\HSP_FMH_UNDO.DAT'
[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\DBPROD02\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 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...
>> 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\DBPROD02\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 Broken
>>
>|||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...
>> 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\DBPROD02\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 Broken
>>
>
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\DBPROD02\UndoTransactionLog\HSP_FMH_UNDO.DAT'
[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\DBPROD02\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 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...
>> 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\DBPROD02\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 Broken
>>
>|||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...
>> 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\DBPROD02\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 Broken
>>
>
Friday, March 9, 2012
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.
>
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.
>
Wednesday, March 7, 2012
Restore needs too much space
I'm trying to restore a database from a complete backup (70MB)
and on restore it says that the restore needs 713MB of free space to
continue
Why? and is there a way to get around this?
I assume the transaction log is the suspect...The size of the backup file is usually unrelated to the actual size of the
files that make up the database. It is more aligned with the amount of data
in the files. You really don't have a choice but to find enough disk space
to restore the database to. You can use the
RESTORE HEADERONLY
RESTORE FILELISTONLY
commands to see what is on the backup device.
--
Andrew J. Kelly SQL MVP
"Ben" <test@.test.com> wrote in message
news:OzMXO6IZFHA.220@.TK2MSFTNGP10.phx.gbl...
> I'm trying to restore a database from a complete backup (70MB)
> and on restore it says that the restore needs 713MB of free space to
> continue
> Why? and is there a way to get around this?
> I assume the transaction log is the suspect...
>|||When you restore a backup, the transaction log file is expanded to the
size it had when the backup was made, but it remains empty (the actual
log records are not stored in the backup, only the size of the
transaction log).
Razvan|||And if the data file where, say, 2 GB, but only contained 1.5 GB of data,
you would still need the 2 GB in order for the store to create the original
2 GB data file and then restore the 1.5 GB into.
Sincerely,
Anthony Thomas
"Razvan Socol" <rsocol@.gmail.com> wrote in message
news:1117432747.852108.163660@.z14g2000cwz.googlegroups.com...
When you restore a backup, the transaction log file is expanded to the
size it had when the backup was made, but it remains empty (the actual
log records are not stored in the backup, only the size of the
transaction log).
Razvan
and on restore it says that the restore needs 713MB of free space to
continue
Why? and is there a way to get around this?
I assume the transaction log is the suspect...The size of the backup file is usually unrelated to the actual size of the
files that make up the database. It is more aligned with the amount of data
in the files. You really don't have a choice but to find enough disk space
to restore the database to. You can use the
RESTORE HEADERONLY
RESTORE FILELISTONLY
commands to see what is on the backup device.
--
Andrew J. Kelly SQL MVP
"Ben" <test@.test.com> wrote in message
news:OzMXO6IZFHA.220@.TK2MSFTNGP10.phx.gbl...
> I'm trying to restore a database from a complete backup (70MB)
> and on restore it says that the restore needs 713MB of free space to
> continue
> Why? and is there a way to get around this?
> I assume the transaction log is the suspect...
>|||When you restore a backup, the transaction log file is expanded to the
size it had when the backup was made, but it remains empty (the actual
log records are not stored in the backup, only the size of the
transaction log).
Razvan|||And if the data file where, say, 2 GB, but only contained 1.5 GB of data,
you would still need the 2 GB in order for the store to create the original
2 GB data file and then restore the 1.5 GB into.
Sincerely,
Anthony Thomas
"Razvan Socol" <rsocol@.gmail.com> wrote in message
news:1117432747.852108.163660@.z14g2000cwz.googlegroups.com...
When you restore a backup, the transaction log file is expanded to the
size it had when the backup was made, but it remains empty (the actual
log records are not stored in the backup, only the size of the
transaction log).
Razvan
Subscribe to:
Posts (Atom)