The Audit Module for PowerShell includes some sample scripts that you can use to do database rotation; rotating a database involves creating a new audit store database and making the new database the active database for the installation. You can copy and modify the sample scripts to use the code directly in your environment or study the syntax used in the script to serve as an example for writing your own custom scripts.
This PowerShell script demonstrates how to use the following cmdlets to do database rotation:
This PowerShell script demonstrates how to do database rotation using the SQL scripts and PowerShell cmdlets.
You can modify the file path settings in these SQL scripts to create a new audit store database using the New-CdaDatabase cmdlet with the DatabaseScriptFile and ServerScriptFile parameters. This case is useful if you want to create a new audit store database with a customized database file folder path, database log file folder path, or database full-text catalog root path.
If you want to use these SQL scripts and you also want to customize the StoredProcedureAccount, IsAwsRds, and IntegrityCheckEnabled settings, you also need to customize the settings in the SQL scripts instead of using the StoredProcedureAccount, IsAwsRds, and IntegrityCheckEnabled parameters. These three parameters can't be used along with the DatabaseScriptFile and ServerScriptFile parameters.
To run the sample script:
- Open the Centrify Audit Module for PowerShell.
- Verify you have permission to execute scripts.
In most cases, the permission to execute scripts is restricted. You can use the
Set‑ExecutionPolicyto allow execution. For example:
For more information about execution policies and the options available, use the
Verify you are in the directory where the
db_rotation.ps1script is located.
Execute the sample script.