Jay Carax
asked on
SQL script to monitor recovery model changes and last time a backup was taken.
Hello
I need a script that will alert me via email if one of the following events occur:
1. A new database is created.
2. Recovery model not set to FULL.
3. There is no full backup for a database.
I would like this script to be dynamic if possible, and by that I mean that an email is sent the moment the recovery model is changed - is this possible or will I have to schedule it to run on a regular schedule?
Our SQL estate is a mixture of 2008R2 and 2005 but there is still one pesky box on 2000.
Many thanks
I need a script that will alert me via email if one of the following events occur:
1. A new database is created.
2. Recovery model not set to FULL.
3. There is no full backup for a database.
I would like this script to be dynamic if possible, and by that I mean that an email is sent the moment the recovery model is changed - is this possible or will I have to schedule it to run on a regular schedule?
Our SQL estate is a mixture of 2008R2 and 2005 but there is still one pesky box on 2000.
Many thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.