· Feb 16

Can you compact and truncate only on shadow server 2022.1 (Build 209U)

Hi we have started to get rid of orphaned data and would like to soon compact and truncate the database as will have about 40gb free to return to filesystem after the few weeks of running the new task. 

The idea would be to do this on the shadow server first of mirror rather than primary. 

Is there any reason this is a bad idea? Considering this needs done on both servers of mirrored db? As idea would be to do this on shadow server before we failover to the server a few days afterwards. And do the same for the month afterwards. 

Also note we have tested our compact and truncate against a non production environment that has been a restore of the live backup db to be able to test this before we do this truncating. 

Product version: IRIS 2022.1
Discussion (3)1
Log in or sign up to continue