As part of understanding our SQL Server environment and trending activities, I’ve been implementing various PBM policies, one of my favorites is based on a Paul Randal blog that lets you track the difference from the last full backup.


With a few tweaks, I was able to convert it into a Policy so I can run it against all the databases in production.  You still need to install Paul’s Function onto each instance you want to run the policy against.

Using EPM (http://epmframework.codeplex.com/) I can view how active the databases are to plan our backup/restore strategy.

 You can download the Policy below. To import it simply Open SQL Server Management Studio. in Object Explorer, open Management, Policy Management, right click on Policies and choose “Import Policy”