|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Logshipping problem. need to do the below ASAPI 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. |
|||||||||||||||||||||||