How to determine database used size?

• v_krishnan

  Say Hey Kid

  Points: 676

  More actions

  August 5, 2003 at 5:11 am

  #160297

  Hi,

  I am using MSDE as my backend database to store my data. Since, MSDE has a 2GB limit on the size of the database, I have a problem that needs to be tackled. How do I determine that the database is about to be filled up, so that I can cleanup certain tables, like remove some records, to get back some free space? Also, how do I clear the transaction log for the database? Does the 2GB limit include the space taken by the transaction logs???

  Thanks,

  krishnan

• Jeremy Kemp

  SSCertifiable

  Points: 6754

  More actions

  August 5, 2003 at 6:07 am

  #468615

  sp_spaceused without a table name gives the unallocated space in the current database.

  Jeremy