Geek asks and answers

Database took up more space than joined tables

I have a database covering almost 7 concerts. If I look at using a table, it should be much less than 40 megabytes. There was a large log table that I deleted yesterday, but my database still says that it is very large.

Here are the stats:

database_name   database_size   unallocated space
Umbraco_Indoorpower 6911.56 MB  859.59 MB

reserved    data    index_size  unused
31144 KB    26272 KB    3240 KB 1632 KB

I ran this:

DBCC SHRINKDATABASE (umbraco_indoorpower, 99);

And this led to my database reaching 2.3 gigs. However, too big.

database_name   database_size   unallocated space
Umbraco_Indoorpower 2302.44 MB  1.63 MB

reserved    data    index_size  unused
30016 KB    26200 KB    3240 KB 576 KB

I assume that I am not freeing up all the space from this log table that I deleted yesterday. I really ran delete from tblLog. Perhaps this was the wrong way.

Does anyone know how I can free up more space?

+3
source share
4 answers

? ? , database_size, , 7 . - , :

EXEC umbraco_indoorpower..sp_helpfile;

, LDF HUGE, MDF . , , FULL recovery . , :

USE umbraco_indoorpower;
GO
BACKUP LOG umbraco_indoorpower TO DISK = 'C:\some_path\umbraco.trn';
GO
DBCC SHRINKFILE(umbraco_indoorpower_log, 20); -- guessing on target MB size here

( , , - , - , , ?)

(a) , /diff/log, (b) , .

, .

, , , , , . . . , " ". , :

http://sqlblog.com/blogs/aaron_bertrand/archive/2009/07/27/oh-the-horror-please-stop-telling-people-they-should-shrink-their-log-files.aspx

+7

. : Script , ( SSMS ) Script .

, ( ). : .

+1
source

Another thing that might take up more space in SQL Server is the Service Broker queue. In my case, I have 6 million lines in queues that occupy 17 GB ...

0
source

More articles:


All Articles