Comments (4)

  1. mbourgon says:

    Did something similar using the system tables, where I use them to see what backups we actually have on disk, as opposed to what we _should_ have.  (see the linked URL – basically, gets a directory list, then scans it using xp_cmdshell, and compares the two)  

    Another use: size trending.  The database size (pre-compression, IIRC) is in there, which means you could query back quite a while and show how much each database is growing.  Useful for capacity planning.  

    Also, you could use them for documentation, since you have a listing for where every database backup resides.

    There’s a plethora of uses for these tables.

  2. Alan Craig says:

    Love the Disclaimer. May I use it on my blogs? Proper credit will be given.

  3. BuckWoody says:

    Alan – feel free!

Skip to main content