% Difference Since Last Backup – Using Policy Based Management
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”
SQL Notes From The Underground 
[…] getting Pauls awesome little function into PBM (https://sqlnotesfromtheunderground.wordpress.com/2013/10/21/pbm-difference-since-last-backup/) and having it run a while, i needed to start looking at the results. And seeing where i can make […]
Really interested in checking out your PBM policy example but the link seems to be old…is it elsewhere? http://sdrv.ms/122IOs4 Thanks.
Hi, not sure why OneDrive keeps erasing stopping them working. updated it again.. let me know if you get any issues..
Cheers
[…] about before, which is monitoring the changes to the database based on Paul Randall function (read my post here). This lets me track weather it’s best to do nightly full backups or maybe look at saving […]