Bob_be
December 2, 2023, 5:27am
3
In Microsoft SQL Server Management Studio, right click on Database -> Reports -> Standard Reports -> Disk Usage by Table then sort by size. Post a screen shot of the results.
This might post might be of some help:
What does the table ReportTemp do?
It is not deleted when running the default Clear Database task. I tried deleting the data in dbo.ReportTemp and it reduced the backup database size from over 100mb to just 2.7mb. I also haven’t encountered any issues with using Samba so far, but am concerned that it may have broken Samba somewhere.
File size comparison after and before truncating ReportTemp table:
[image]
Before truncating the table:
[image]
After running TRUNCATE TABLE ReportTemp; in SM…
This may also be of interest, read the post in it’s entirety:
[General Info]
Application: SambaPOS
Version: 5.3.0
Region: en
DB: SQ
Machine: SERVER
User: Administrator
Date: 21 Mar 2022
Time: 13:21
User Explanation:
1 Like