Space used

• Roust_m

  SSCoach

  Points: 17410

  More actions

  June 30, 2003 at 2:17 am

  #59686

  Hi!

  Trying to find out how much space is available, first try to see the properties of database: it says Space available: 0,00 MB

  Run sp_spaceused:

  database_name database_size unallocated space

  -------------------------------------------------------------------

  maindb 7200.00 MB -3318.48 MB

  reserved data index_size unused

  ------------------ ------------------ ------------------ ------------------

  10566120 KB 5847320 KB 1436056 KB 3282744 KB

  The log of the db is 200Mb and is currently used by 25%

  What is the actual space available in the database?

• Ian Scarlett

  SSC-Insane

  Points: 23197

  More actions

  June 30, 2003 at 2:50 am

  #463613

  Try running sp_spaceused @updateusage=true