Return
-
Title
Can the SQL server hosting the Active Administrator database be brought offline for maintenance? -
Description
Are there any issues with taking the SQL server hosting the AA database offline for maintenance? -
Resolution
If possible, it would be best to take the SQL server hosting the AA database offline during non peak hours to help reduce the risk of loss of audit data.
While the SQL server is offline, you will see alerts that the agents cannot write to database as well as temp files in the Agent folders on the agents will grow. Once the database is online again, the temp files will be written to the database.