Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
patshaw
Posting Yak Master
177 Posts |
 Posted - 2008-10-18 : 08:57:28
|
| As part of a Log Shipping setup I have a restore job running every 20 minutes that scrolls through a cursor, taking the name of each db to restore, and restores the backups accordingly. The problem is that occasionally, and at random times, the job will hang and not complete, even though the restores have completed. This obviously prevents the future restore jobs from starting and forces the backup files to stack up. The only way to put this right is to kill the stuck job which seems to then go into never ending rollback, restart SQL services to kill the rollback (as it doesn't seem to be actually rolling anything back) and then all is ok. There is no problem with the backup job on the source server so the files are always there to be restored. Has anyone run into anything similar and if so, how did you solve it? |
|
|
patshaw
Posting Yak Master
177 Posts |
Posted - 2008-10-18 : 09:00:24
|
| BTW. I cannot find any related error messages in the logs. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Restore Job doesn't always complete