Database recovery model change notification report for SQL Server

Posted on SQL Server Central See other posts from SQL Server Central
Published on Wed, 02 Nov 2011 06:00:00 UT Indexed on 2011/11/13 2:02 UTC
Read the original article Hit count: 288

Filed under:

The database recovery model plays a crucial role for the recovery of a database. With several DBAs having access to a SQL Server instance there are bound to be changes that are not communicated. In this tip we cover a monitoring solution we deployed at our company to alert the DBAs if a database recovery model is different than what it is expected.

SQL Monitor The Future of SQL Server Monitoring
Monitor wherever, whenever with Red Gate's SQL Monitor. See it live in action now.

© SQL Server Central or respective owner