I have a database in SQL Server 2008 that is reporting it is 1.5GB when the actual size is a fraction of that.
EXEC sp_spaceused reports that the database is 1533.07MB
EXEC sp_msforeachtable 'EXEC sp_spaceused [?];' reports the following sizes;
activejobs - 4832KB
queuelog - 1496KB
Does anyone know why the size of the file is 1.5GB? Is there a way to reduce this?
EDIT: I attached an image of the size results.