Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Shrink database does not work much
Message
 
 
To
09/04/2010 11:29:22
General information
Forum:
Microsoft SQL Server
Category:
Database management
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01459415
Message ID:
01459473
Views:
48
>Here is the result. See the attached file. Basically, it seems the index is taking a lot of space. This is probably where the problem is. I see also that only two tables are subject to have space reserved for them. Do you see something in there that could be addressed?

It's hard to tell anything w/o info about indexes. What's strange that total index size is about 14MB but I see only 5 MB used by tables. Maybe it's in the rest of report that is not included in the picture?
All tables have space reserved. You cannot see it in this report because it doesn't reach 1MB per table.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform