MDF size way too large

From: Lucvdv <replace_name@xxxxxxxx>
Date: Fri, 22 Dec 2006 11:09:52 +0100

I've got a SQL Express database with, right after running DBCC
SHRINKDATABASE, an MDF file size of 1.59 GB. The log file size is
neglectable, less than 1 MB.

The database properties say size 1632.50 MB, 159.07 MB available.

When I look at the properties of all tables individually and add their data
and index sizes, they add up to 590 MB.

What's it using the other 1GB for?

.

Follow-Ups:
- Re: MDF size way too large
  - From: Lucvdv

Prev by Date: any good books for sql server 2005 express edition?
Next by Date: Re: MDF size way too large
Previous by thread: any good books for sql server 2005 express edition?
Next by thread: Re: MDF size way too large
Index(es):
- Date
- Thread

Relevant Pages

Re: How critical is the transaction log file?
... Tibor Karaszi, SQL Server MVP ... file when you have only one file (no log file). ... circumstances it is supported to attach only an mdf file. ... > This development database that we're building does not have any 'user' ...
(microsoft.public.sqlserver.tools)
Re: Attach
... database wasn't detached cleanly. ... What happened to the log file? ... Jasper Smith (SQL Server MVP) ... > How can I reattach a MDF file with only the .MDF available? ...
(microsoft.public.sqlserver.setup)
Re: MDF size way too large
... an MDF file size of 1.59 GB. ... The log file size is ... The database properties say size 1632.50 MB, ...
(microsoft.public.sqlserver.msde)
Re: sp_attach_single_file_db
... > Andrew J. Kelly SQL MVP ... >>I only have a MDF file not the log file and I used the following command ... CREATE DATABASE is aborted. ...
(microsoft.public.sqlserver.clients)
Re: "Hidden" Replication Stored Procedures?
... aforementioned MDF file in Notepad and doing a quick search, ... Is there a way to have the Resource Database appear in the list of Databases ... Chris Jones ...
(microsoft.public.sqlserver.replication)