When a new Archive Database is created, it is essentially a blank database with the MDF and LDF files set to MAXSIZE = UNLIMITED, FILEGROWTH = 10%
The Archive Job will then first copy over Non-Audit Event tables such as Event Class
Then it will review the production database to determine which events need to be copied to the Archive, based on the Archive Job settings defined in the Client
It will then copy events in batches to the Archive Database
As the Events are copied to the Archive and space is used, the SQL Server will grow the Database Files by 10% (AUTOGROW)
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center