12 April,16 at 11:44 AM
Applies to:
Centrify DirectAudit 2.x SDK
Question:
Using the DirectAudit SDK to create and manage the database, it is noticed that the API creates a database and then sets the autogrowth default property to 'unrestricted'.
This has the potential to completely fill up the disk and cause further issues.
Is it possible to set autogrowth to 'restricted' while creating the database?
Answer:
Use db_rotation_sql_script.vbs instead of db_rotation.vbs and modify SetupServer.sql (this file is in the same location as db_rotation_sql_script.vbs).
Search for CREATE DATABASE and locate the "MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB" sql statement, modify the MAXSIZE value to the desired size.