#Customize a Database for Report Center

You can designate a custom database in Microsoft Azure SQL to store the retrieved audit data for Report Center Compliance Reports.

AvePoint currently provides unlimited storage space for storing audit data, and your audit data will be compressed and stored to Azure blob storage.

Note that the Audit Pruning feature will not manage the audit data stored in the unlimited Azure blob storage, but it can still be used for pruning the legacy data stored in the default database or the data that you choose to store in a custom database.

Complete the steps below to add a custom Report Center database:

1. Navigate to Control Panel > Database Configuration > Report Center Database.

2. In the Database Configuration tab, the default database used by Report Center is displayed in the table showing the used space and the free space.

3. Click Add. The Add a Report Center Database window appears.

4. Enter the hostname or IP address of the database server into the Database Server text box, and then enter the database name.

   NOTE

   The entered database must have more than 1 GB of free space.

5. Enter the username and password in SQL Authentication to access the database. Click Validation Test.

   NOTE

   The user used to access the database must have the db_owner role in the added database.

6. After successfully testing the information, click Save to save this custom database.

The custom database will be displayed in order of when they were added to the table for Report Center Database. The databases will be used in order.

You can perform the following actions on the existing custom databases:

• Edit – Select the database you want to edit, then click Edit on the ribbon. You can change the authentication information as desired, and then click Save to save your edits.

• Remove – Select the database you want to remove, then click Remove on the ribbon. A confirmation window notifies you that the reports generated with the associated database will become unavailable. In addition, if the retrieved data of a site collection is stored in the removed database, the data retrieval job that is retrieving data of the site collection will fail as the database cannot be connected.