gruney
6
FileSystem_FileInfo.db has gotten too large, I assume because I checked the File System Analyzer option to Track individual file information. I have since unchecked that option, but the database size has not decreased. Database cleanup does not decrease the size either when reducing the number of days to keep data.
Am I missing a setting or option to reclaim the disk space?
Hi Gruney,
When you change the retention settings for the database the change will take 24 hours to complete. So you will see after that time the data has been removed from the database. The issue is that the database size will not change unless you change it manually. On SQL Servers I believe there are some automatic settings that you can use and there are some manual things you can do to change the size. If you are using our embedded database we have a command line option that you can use to change the size. Here is a link to read more about that. Look for "/COMPRESS_DATABASES".
Thanks
Quinn
Please make sure to mark your questions accepted when you have your answer by clicking the gray check mark to the left of the answer.
Thanks Quinn. I am using the embedded database, so I will try that command line.
I have manually shrunk our WSUS databases before using SQL Server Management (following someone else's instructions), so I was familiar with that but a similar approach was not working for the PA databases.
I will be back to mark this as answered if I don't run into more questions.
The command seemed to be working. It ran through the small databases quickly and slowed down on the larger ones. The process finished, but the file sizes did not change. The console says the service is running again. "Services" says PA Storage Monitor is not started, but I think that is the scheduled service that is not supposed to be running all the time. The midnight reports ran as usual, but the emails were not sent.
You can look in the services log file to find out why the emails weren't sent.
I'm not sure about the services running.... Did you refresh the Services?
If you use PA Admin System Monitoring, it´s possible to face the same situation.
Ich this case the comandline in the PA programmfolder is:
ServerMonSatellite.exe /compress_databases.
MTE
