Script to Get the Database size in GB's

  • Comments posted to this topic are about the item Script to Get the Database size in GB's

    --

    Thanks & Regards,
    N.S.Sathish(SQL DBA)

  • One thing to keep in mind is that this returns the combined size of the DB and log files for each database rather than just the size of the .MDF.

  • This is great and so close to what I'm looking for. However we do have several databases that consist of several ndf files, this only shows me the main file and it's location. Is there a way to modify this so it can show me each file? I also have been asked to include if the database is mirrored or not. I have been trying to mod it on my end so far, my skills are not there.

    ----Just figured this out, by changing the where filter to type. Sorry, can't seem to delete this post.

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

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