Ive setup log shipping for two of my databases to a server so I can run reports against the 2nd server. Once I set it up, the process runs quite happily for 3/4 days then the restore process of the logs to the secondary server starts to fail. The copying of the files is still working its just the restore side which is failing. The only way to get this back up and running is to remove the log shipping options and resetup the process.
How can I identify the problem? Ive checked the job history of the restore process and this is the error.
Date 08/03/2011 10:10:00
Log Job History (LSRestore_HOGWARTS_GoldMine)
Step ID 1
Job Name LSRestore_HOGWARTS_GoldMine
Step Name Log shipping restore log job step.
Sql Severity 0
Sql Message ID 0
Operator Net sent
Retries Attempted 0
Executed as user: CLONER\SYSTEM. The step failed.