get size of MSDE db

• dudek

  Newbie

  Points: 2

  More actions

  August 11, 2006 at 9:11 am

  #62102

  Hi Everybody,

  I'd like to get the size of my database (MSDE) before it hits the 2GB limit.

  If I run sp_spaceused what counts for the limit? 'reserved' or just 'data'?

  For sure not the whole 'database_size' because of the log size it contains - this does not count for the 2GB limit...

  Thanks in advance

  TomY

   

• August 14, 2006 at 8:00 am

  This was removed by the editor as SPAM

• dudek

  Newbie

  Points: 2

  More actions

  August 15, 2006 at 5:04 am

  #655025

  Nobody can help?!

• Martin Mojzisek

  SSCrazy

  Points: 2207

  More actions

  August 16, 2006 at 4:09 am

  #655223

  you can use this simple query

   

  use

  msdb

  select name,

  size*8/1024.0 as 'Size(MB)',

  FILEPROPERTY(name,'SpaceUsed')*8/1024.0 as 'Used(MB)'

  from

  sysfiles

   

   

  hope this helps