how to - Space used in individual data files?

• karthikp

  Valued Member

  Points: 67

  More actions

  July 8, 2002 at 3:25 am

  #58473

  Is there any undocumented command or script to find out the space used in individual data files of a database that has multiple data files?

• Nick Beagley

  Ten Centuries

  Points: 1349

  More actions

  July 8, 2002 at 6:09 am

  #432165

  In the database you are interested in run: DBCC SHOWFILESTATS

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737034

  More actions

  July 8, 2002 at 9:47 am

  #432181

  Or sp_spaceused.

  Either will force you to do some calculation.

  The full backup is also a good indication of space used. Run one for each filegroup.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones