December 5, 2012 at 11:10 am
I would like to know the size increase rate of a disk drive that stores database backups.
I have overheard from some network people they have a tool to check that, for example to find out in last year- each month what is the size increase of the drive/folder.
Anyone knows what the tool is?
Thanks
December 6, 2012 at 3:11 am
You could just query the backupset table and get the space of the backups that way, unless the drive/folders also store none backup files.
December 6, 2012 at 7:02 am
Couldn't monitoring tools such as SCOM accomplish what you are trying to do?
Joie Andrew
"Since 1982"
December 6, 2012 at 2:17 pm
We capture size a different way, however you can use backup_size in backupset, write to a dim/fact table and build a cube off of. Then drop in an excel pivot table to drive a nice chart showing growth over time..
Regards,
Chris
mssqlconsulting.com
Chris Becker bcsdata.net
December 7, 2012 at 6:58 am
I found this software back in the summer. Has a 15 day free trial. I installed it for testing and it was nice. You can see if it will do what you are wanting.
http://www.foldersizes.com/index.htm
(I have no affiliation with the software company.)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply