Find Size of files used in Database

• nitesh_rd

  SSC Enthusiast

  Points: 110

  More actions

  March 1, 2014 at 5:09 pm

  #304687

  Comments posted to this topic are about the item Find Size of files used in Database

• oradbguru

  Hall of Fame

  Points: 3126

  More actions

  March 3, 2014 at 7:22 am

  #1693552

  This is a basic helpful script. I just added comma formatting to make it easier to read. Thank you.

  SELECT

  Name

  , Filename

  , convert(varchar, cast(convert(decimal(12,2),round(size/128.000,2)) as money), 1) as FileSizeMB

  , convert(varchar, cast(convert(decimal(12,2),round(fileproperty(name,'SpaceUsed')/128.000,2)) as money), 1) as SpaceUsedMB

  , convert(varchar, cast(convert(decimal(12,2),round((size-fileproperty(name,'SpaceUsed'))/128.000,2)) as money), 1) as FreeSpaceMB

  FROM

  dbo.sysfiles