mardi 30 décembre 2014

How can i automate the process of log shipping monitoring


I have log shipping configured between my Prod SQL server 2005 and QA SQL server 2005. Per the requirement from Business we need to provide them with a report at the end of the day for the LOG shipping configured for multiple databases on their respective instances.


If i go manually and use standard reports, i am able to achieve this. But is there a way i can get such a report send via e-mail confirming the status of Log shipping configured amongst various DB;s in an instance.


Thanks Kapil





Aucun commentaire:

Enregistrer un commentaire