Database size growing too large

[Anthony_TMEIC]

My database seems to have grown exponentially over the last few weeks despite not gaining that many new assets:

Microsoft SQL Server 2014 (SP3) (KB4022619) - 12.0.6024.0 (X64) Sep 7 2018 01:37:51 Copyright (c) Microsoft Corporation Express Edition (64-bit) on Windows NT 6.3 <X64> (Build 18363: )
Database: lansweeperdb
Server: (localdb)\.\LSInstance
Schema Version: 231
Assets: 1603
Size: 8874.50 MB
Unallocated: 351.75 MB

My biggest table is:
Table Total Rows Reserved (KB) Data Size (KB) Index Size (KB) Unused Size (KB)
tblAssetJournal 8698667 7800568 7774576 24728 1264

I have done compact/shrink from database maintenance tool.

Any ideas what has happened?

[ldockery]

GulfMarco wrote:
I turned off and deleted the enterprise setup, only then did the database stop growing. Mine never fully sync'ed up, and database grew to 30+ GB weekly or bi-weekly, crashing the servers.

How did you delete the enterprise setup?

[chris_anderson]

I ran into the same issue. Though now i have turned off the Enterprise connection but the table still grows like crazy. I just keep having to go in and delete all the records from the table. Not sure why it is still being used if the Enterprise option is turned off.

[GulfMarco]

Mine has, too. Interesting. I'm also trying Enterprise.

[grimstar]

Are there timestamps associated to the entries in that table? Maybe you can identify what the entries looked like prior to you noticing this uptick and see if there is something new populating that wasn't previously.

In the end you might have to contact support directly on this one. If it is related to Enterprise they may have made a chance on the cloud side that resulted in additional data populating this table.

[Anthony_TMEIC]

I have an extremely limited knowledge of SQL so when I ran a query through Management Studio I didnt see anything offhand I could recognize as an issue.

[grimstar]

Have you queried that table to see what is in there? I found something that said it used with the Enterprise Edition, which I do not have installed.