Home All Groups Group Topic Archive Search About

Logshipping problem. need to do the below ASAP

Author
23 Mar 2006 9:53 PM
Tejas Parikh
Hey. I've logshipping setup right now. What I want to do is look for

I need to setup a job that would run every 5 minutes to look for
'Error: 3456, Severity: 21, State: 1' in the error log.
If this occurs, I need the second step in this job to run a differential
backup on ServerA.
In the third step, it should start jobB on ServerB
(jobB drops the affected db and restores it from a backup and then will do
the restore of the differential). I've jobB setup already.
In the fourth step, I need SQL to email me with the problem from sysmessages
or something.

All this is related to logshipping. I've a db which is being logshipped but
it fails every other day or seomthing with the error I pasted above. I need
to set this up ASAP and then work on how to solve the problem.
I dont want to use linked server to start job on another server.
Is there any other way i can do this?

Thank you
Please let me know how do i do this.

AddThis Social Bookmark Button