Post reply

DB size information

  • February 2, 2005 at 9:15 am

    #60229

    Is there information kept in system tables at the DB level that would provide the size of the ldf and mdf, and the free and used space in each?

    I am trying to set up some queries for Excel so I can periodically populate an excel spreadsheet to store a snapshot of our DB size information and calculate growth information.

    Currently I am manually populating information on 60+ databases - doesn't seem like the best way.

    Thanks

    Ryan

  • February 2, 2005 at 9:49 am

    #540192

    I have a a stored procedure, I've uploaded to the contribution center and is pending approval, that reads through the list of databases and stores the the data you want in a table in the master database.

    Then you would just extract it to Excel (or in my case I pull it into an Access DB) for reporting.

    PM your e-mail and I'll send it to you.



    ----------------
    Jim P.

    A little bit of this and a little byte of that can cause bloatware.

  • February 2, 2005 at 11:33 am

    #540227

    Thanks Jim.  I just sent you the address. RH

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply