Several questions about data space in SQL 6.5

• jsciii

  SSCommitted

  Points: 1536

  More actions

  October 24, 2002 at 6:21 am

  #58095

  I need to find out how much space is being used by all the data in a database. I have a database with 5 database devices for a total of 20 gigs. When I do a backup it says 6 gigs have been back'd up.

  Can I use this as an accurate count of data usage? Does this mean I have 14 gigs of free space?

  What tools are available to me to determine data and log space usage?

  If possible, please send any help to john.s.clark@lmco.com

  Thanks in Advance....JC III

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  October 24, 2002 at 7:58 am

  #439349

  use yourdatabase

  go

  exec sp_spaceused @updateusage = 'TRUE'

  go

  dbcc sqlperf(logspace)

  go

  Edited by - Allen_Cui on 10/24/2002 08:08:11 AM