July 14, 2008 at 12:17 am
Hi there,
I have 3 databases logshipping all at different times. However they fail intermittently
Date7/14/2008 3:00:00 PM
LogJob History (LSRestore_IBTKYPSP32A034_EnterpriseVaultDirectory2)
Step ID1
ServerIBTKYPSP32B034\HOSTED_P1
Job NameLSRestore_IBTKYPSP32A034_EnterpriseVaultDirectory2
Step NameLog shipping restore log job step.
Duration00:00:06
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
Executed as user: AD\g-tky-sqlmail. The step failed.
I was wondering if anyone else has had this problem, the other dbs are using the same user so I cant see why it fails and when I take off logshipping it works for a while and then fails again.
Regards,
Terry
July 15, 2008 at 4:26 pm
I have seen log shipping restore jobs fail when the copy job is still running due to a large log file. A reindex job was the culprit in my case.
You may try lowering your backup/restore interval to keep the logs smaller.
July 15, 2008 at 4:49 pm
check the logshipping tables in msdb, should give you more of a clue as to why it failed
---------------------------------------------------------------------
July 17, 2008 at 1:59 am
cheers guys I have sorted it out, i changed the restore times to 30 mins and it seems to be working again, fingers crossed it does not break again or i might have to think about db mirroring
Terry
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy