Post reply

Get database sizes every night on every server

  • March 27, 2006 at 12:56 pm

    #171022

    Hi, I am in need of tracking the sizes of databases on a nightly basis.  We have about 15+ servers some with multiple user databases.  What is the best way to obtain database sizes for each database programatically?

    thanks

     

  • March 27, 2006 at 1:09 pm

    #629005

    I used to setup a separate admin database on each server. Use scripts to grab the size of each database, and you can find a few on this site.

    Then use linked servers or a batch job, or even DTS to roll that up to one of the servers and get a report. Separating this to each server means that a failure or issue only affects that server. And it keeps the history with the server. If you move a db, be sure to move the server.

  • March 27, 2006 at 1:16 pm

    #629006

    http://www.databasejournal.com/features/mssql/article.php/3339681

     


    * Noel

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

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