Microsoft SQL 2005 non used or static data tables - how do I find?
Posted on 2014-01-22
I am looking for a way to reduce the size of my SQL backups, I have a massive 400gb backup going on every night and I am sure most of that is static data. My question is how do I monitor the tables to find out which ones are static or unchanged for a month or so. If I can find which ones are static then I can concentrate the backups on the changed tables and even create ndfs to suit.
Are there any tools built in, or are there any free tools available to do this task?