Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Size Of Database

Author  Topic 

sleonard84
Starting Member

1 Post

Posted - 2008-06-01 : 16:48:10
I have a database that is almost 1.55 GB in size according to the database properties window.

However I checked the size of all the tables and indexes using the stored procedure 'sp_spaceused' and the sysindexes table and the total size of all tables and indexes is only 162 Mb.

Does anyone know why the database is so big, and how I may be able to reduce the size of it?



Steve

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-01 : 21:57:31
Check this one from Booksonline:
http://msdn.microsoft.com/en-us/library/ms179316.aspx
you can shrink with DBCC shrinkdatabase but that shuffles index pages and cause fragmentation.
Go to Top of Page
   

- Advertisement -