- Joined
- Aug 11, 2011
- Messages
- 4,357 (0.87/day)
- Location
- Mexico
System Name | Dell-y Driver |
---|---|
Processor | Core i5-10400 |
Motherboard | Asrock H410M-HVS |
Cooling | Intel 95w stock cooler |
Memory | 2x8 A-DATA 2999Mhz DDR4 |
Video Card(s) | UHD 630 |
Storage | 1TB WD Green M.2 - 4TB Seagate Barracuda |
Display(s) | Asus PA248 1920x1200 IPS |
Case | Dell Vostro 270S case |
Audio Device(s) | Onboard |
Power Supply | Dell 220w |
Software | Windows 10 64bit |
First I don't really know my way around DBs (I'm just the "guy good with computers" around here) so if I'm making some sort of newbie mistake, please bear with me.
So there's an accounting program that we use at work and suddenly the PC where it's installed filled up its 500GB HDD
Looking around I saw that the folder C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG was the culprit as it had >500,000 files (explorer crashed when I tried to open it, had to use the command line).
So I deleted the files but after checking again after a week I find that the folder has again grown to 12GB, so I set to try and discover the problem.
Now the actual problem is that a single database used by the program is generating several SQLdump files per minute just by being open. The weird thing is that the accounting program has 5 similar databases (one for each account) and that single one has this problem.
The tools at hand:
MS SQL Server Manager Studio Express
Things I've tried:
- Setting AutoClose to False
- Setting Recovery mode to Normal
- Backing up the DB, deleting and restoring
Nothing seems to stop the barrage of files being created.
Pics:
Highlighted: file number and size, the DB involved
Highlighted: DB opened (just opened, no transaction has taken place), several files had been created in just 10 seconds.
Thank you for any input.
So there's an accounting program that we use at work and suddenly the PC where it's installed filled up its 500GB HDD

Looking around I saw that the folder C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG was the culprit as it had >500,000 files (explorer crashed when I tried to open it, had to use the command line).
So I deleted the files but after checking again after a week I find that the folder has again grown to 12GB, so I set to try and discover the problem.
Now the actual problem is that a single database used by the program is generating several SQLdump files per minute just by being open. The weird thing is that the accounting program has 5 similar databases (one for each account) and that single one has this problem.
The tools at hand:
MS SQL Server Manager Studio Express
Things I've tried:
- Setting AutoClose to False
- Setting Recovery mode to Normal
- Backing up the DB, deleting and restoring
Nothing seems to stop the barrage of files being created.
Pics:

Highlighted: file number and size, the DB involved

Highlighted: DB opened (just opened, no transaction has taken place), several files had been created in just 10 seconds.
Thank you for any input.

Last edited: