Determining data size

• khalprin

  Mr or Mrs. 500

  Points: 576

  More actions

  December 20, 2010 at 8:19 am

  #232174

  I'm trying to determine the correct way to get the size that applies to the limits for sql express. I believe that 2005 has a 4GB limit on data and log sizes; 2008 has a 10GB limit only on data size.

  When I execute sp_spaceused (with null database name to get summary) the first result set shows 'database_size'. Is this the value that applies to the limit for sql express 2005? The second result shows 'data'. Is this the value that applies to the limit for sql express 2008?

  Thanks.

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  December 20, 2010 at 8:35 am

  #1264655

  It's pretty easy to figure out.

  Try building a new db with 11 gb of datafile.

  If you can do it, then you know the limit is on the real used space counter.

  My bet would however be on the physical file, rather than real user.