Post reply

DB Size

  • September 19, 2013 at 8:41 am

    #395521

    Why is the database size different than the physical file size? The general page of the database show 12000MB. If I browse to the location of the MDF, it is 8192000KB. Why don't these match? This is an example DB, the rest of my DB's are the same, but not quite as much of a discrepancy.

    Thanks,

  • September 19, 2013 at 8:52 am

    #1651552

    The database size in the database properties window includes the log file size.

    John

  • September 19, 2013 at 8:59 am

    #1651555

    Cool Thank you! So does the space available include both as well? How do I find the free of each individually?

    Thanks,

  • September 19, 2013 at 9:02 am

    #1651556

    I've got a feeling the free space only tells you what's in the data file. Have you tried sp_spaceused?

    John

  • September 19, 2013 at 9:06 am

    #1651558

    The easiest way is probably to look at the Disk Usage report in SSMS. You can access it by right clicking on the database in question, selecting reports, standard reports and Disk Usage. It provides you detailed information about how large each data file is and how much of that space is used.

  • September 19, 2013 at 9:36 am

    #1651569

    Not yet. But I did. Looks like it is only the free space of the data. I also found a space report. I just took over these servers. I had to move this DB from a failed server. When I restored it, it looks like the initial sizes were set to 8GB (DB) and 4GB(log). But it looks like they are only using 1.5GB and 200 MB. The database is not expected to grow that large. Would you recommend shrinking in this case?

  • September 19, 2013 at 9:40 am

    #1651574

    Thanks George. I was in the middle of reviewing that report.

Viewing 7 posts - 1 through 6 (of 6 total)

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