AnsweredAssumed Answered

Compressing PIFD Database

Question asked by VCampus-METCO on Feb 18, 2019
Latest reply on Feb 18, 2019 by sraposo

My virtual machine disk space is starting to get a bit low. Rather than just adding more disk I want to do some housekeeping and one of the things I would like to do is delete a lot of test event frames that I have going back several years.  My idea was to delete these event frames, then use the SQL Server database shrink tool to reclaim the unused space. I was going to just use SQL Commander and do a query to delete the old event frames - but that doesn't seem to be a statement that is supported with OLEDB Enterprise. I had not noticed this before but it seems to be something that should be supported. So I just used PSE to do the same thing rather than writing an App.

 

So my question is whether the SQL Server shrink function can be used while the PI System is running or is there a better way to recover disk space used by PIFD.

Outcomes