SAP B1 DB is expanding unusually
I have this case, My DB is expanding unusually, its now more than 100 GB, yes GB not MB, we have been using B1 for less than 2 years now, I tried to shrink and created maintenance plan. but thats not helping,
We don't have inventory, only we are generating 2000 invoices monthly, and 2000 incoming with checks (12 checks for each incoming), 20,000 JE.
Any advice will be appreciated.
SAP B1 8.82
SQL Server 2008 R2 Std
Windows 2008 R2 64bit