Post reply

Size of all databases with create date

  • January 11, 2013 at 8:04 am

    #272725

    How do i get this with a simple query.

  • January 11, 2013 at 8:09 am

    #1576319

    SELECT

    db.name,

    db.create_date,

    sum(mf.size*8) AS SizeInKB

    FROM

    sys.databases db

    INNER JOIN

    sys.master_files mf

    ON

    db.database_id = mf.database_id

    GROUP BY

    db.name,

    db.create_date

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

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