KB 540105: How to configure Archiver to not export all partitions after install
After deploying the Audit Collection Archiver the solution will start to run daily jobs at 4am that export all inactive partitions that have not been archived. Due to some customers environments, database size, resource limitations or current ACS health it is not always desirable or feasible to export all existing inactive partitions.
Configuration Steps
Run the below SQL command on the ACS audit database to manually update the partition history table so the next job will only process the most recent inactive partition.
Note: This command should only be used on a fresh installation of the Audit Collection Archiver or when applicable.
INSERT INTO [OperationsManagerAC].[dbo].[SvtArk_PartitionHistory]([PartitionId],[PartitionStartTime],[PartitionCloseTime],[ArchiveStatus],[ArchiveDirectory] ,[FileStatus]) SELECT [PartitionId], GetDate(), GetDate(), 1, 'd:\ACS Repository', 1 FROM [OperationsManagerAC].[dbo].[dtPartition] WHERE Status <> 0
The "d:\Archiver" value should be substituted with your actual Archive repository location as should the "OperationsManagerAC" value if not using defaults or applying to multiple databases.
|
|