We have a SQL 2005 sp3 development server with transaction logs located on F drive. Over several weeks' time, the amount of free space on this drive gradually decreases until there is almost none left. However, I don't know what is using up this space. In Explorer when I highlight all of the files/folders on the drive and check Properties, the amount of space used is much less than that of the disk's capacity. For example, it's a 45 GB drive, and although the sum of all the files & folders is 20 GB, it shows only 1 GB free when it should have about 25 GBs available!
After I reboot, the missing 24 GB of space magically comes back. If I don't reboot and merely stop and start the SQL service, the space is not freed up.
TempDB is located on C drive, so that is not an issue here. This is happening consistently over the last few months, requiring a reboot every month or so.
The server has about 35 OLTP databases and 5 data warehouse databases.
I suspect this is SQL related, though I have no evidence to support that. The issue does not happen with the data drive or the system drive. Any suggestions about what to look for? Thanks