Transaction Restore hanging
I used Redgate 5 to do Log Shipping of a database every 5 minutes between two SQL 2005 servers.
The Backup works flawlessly.
The restore job on the second server will occasionally "hang". The job stays executing and doesn't stop at all until manually requested to stop.
I then have to copy the script to restore the logs and paste it in a query. This get the Secondary Database up to date and then the restore job continues until it hangs again.
This database is not being used currently until we get this restore issue fixed. So there shouldn't be anything else that would lock the database.
Is there a way to find out why this job is hanging and what i can do about it?
Also is there a script that can notify me when the job does hang or doesn't restore after a certain amount of time?