Folder & file size

  • Hi,

    I'm rather new to SQL, so excuse this probably stupid question :unsure:

    The size of the folder where my database is stored (the one with the *.mdf and *.ldf files) is 45GB (!) according to Folder > Properties.

    However, when I add up the separate files inside the folder, they are just about 500MB. There are no hidden and/or system files in the folder.

    What's up here?

    Thanks,

    Leo

  • run:

    sp_helpdb to see the actual sizes of your attached databases.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

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

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