Please see this thread that discusses this. Basically, you have to manually shrink the PIFD database. If you decide to do this I highly recommend that you build all indexes since shrinking will increase the index fragmentation level. Generally, it is fine to shrink a database as long as you build the indexes after. You should be able to use AFDiag /reindex to rebuild every index in the AF Server SQL database. I would recommend doing this when there is low activity on the AF Server. See KB 00674 for more OSIsoft comments on re-indexing.
You can use SQL Server Management Studio to shrink the DB.
- Right click on PIFD (or whatever your DB is named)
- Go to Tasks > Shrink > Database
- You'll see how much of the currently allocated space is available, click OK to release unused space.
I just want to add some comments about how PI AF Server works.
Direct delete of an element, will probably be removed synchronously. Deleted AFDatabases get removed asynchronously, and could take hours to get completely removed, depending upon the number of objects. Therefore, you need to wait for some hours until PI AF service finish cleaning up the deleted data stored on PIFD.
Hope it helps!
Good point Marcos! Yeah, it would be a shame to shrink and only to find one has to shrink again.