Page History
...
- Perform a full backup, including the transaction logs
- Schedule the backup during off-hours, or times when you expect the least audit activity
- Back up all event databases during the same backup procedure
- Save each database to a separate backup file
- Back up the SQLcompliance database during the same backup procedure to ensure audit data integrity remains intact
To back up the event databases:
- Use SQL Server Enterprise Manager or Management Studio to take the SQLcompliance database offline. If you cannot take the SQLcompliance database offline, stop the Collection Service.
- Use a tool such as Idera SQLsafe to IDERA
to perform a full backup, including transaction logs, of the SQLcompliance database.Newtablink alias SQL Safe url https://www.idera.com/productssolutions/sqlserver/sqlsafebackup
For each event database, perform a full backup, including the transaction logs. Each registered SQL Server instance has a corresponding event database. For more information, see Product
...
- components and architecture.
- Use SQL Server Enterprise Manager or Management Studio to bring the SQLcompliance database online.