> ## Documentation Index
> Fetch the complete documentation index at: https://syteca.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Database Management Settings

> View database connection details and access Archive & Cleanup, Test Database Connection, Shrink Transaction Log, and Update Statistics from the Configuration page.

<Warning>
  **NOT AVAILABLE IN SAAS.**
</Warning>

<Note>
  Requires the [administrative Database Management permission](/docs/administration/users/administrative-permissions). Identical for the built-in default tenant's admin and for tenant admins in Multi-Tenant mode.
</Note>

<Steps>
  <Step title="Open Database Management">
    Click **Configuration**, then select the **Database Management** tab.
  </Step>
</Steps>

## Database Settings

A read-only summary of the active database connection: **Type** (MS SQL Server or PostgreSQL), **Database version**, **Database name**, and **User name**.

## Archive Parameters

Add an archived database and configure [Archive & Cleanup parameters](/docs/administration/deployment/database-management#archive-and-cleanup-parameters) for your database type.

<Frame caption="The Database Management tab, showing the Database Settings summary above Archive Parameters.">
  <img src="https://mintcdn.com/syteca/0FlD-vkHsBA1azVX/images/administration/configuration/database-management-settings.png?fit=max&auto=format&n=0FlD-vkHsBA1azVX&q=85&s=7f8d5a4a2b34d890e8d503cbb9d06607" alt="Database Management tab showing database settings and archive parameters" width="1887" height="946" data-path="images/administration/configuration/database-management-settings.png" />
</Frame>

## Buttons available at any time

* **Test Database Connection** — confirms whether the Application Server currently has an active connection to the archived database (and its binary storage location, if configured), and reports the result in a pop-up.
* **Shrink Transaction Log** *(MS SQL Server only)* — see [Shrink the MS SQL database transaction log](/docs/administration/deployment/database-management#shrink-the-ms-sql-database-transaction-log) for what this does and its limitations.
* **Update Statistics** *(MS SQL Server only)* — rebuilds database indexes for faster query performance. For a more thorough, scheduled approach to index maintenance, see [MS SQL index maintenance](/docs/administration/database/ms-sql-index-maintenance).
* **Save** — applies and saves changes made on this tab.

## Related

<CardGroup cols={2}>
  <Card title="Database management" icon="database" href="/docs/administration/deployment/database-management">
    Archive, cleanup, and validation settings in full detail.
  </Card>

  <Card title="MS SQL index maintenance" icon="database" href="/docs/administration/database/ms-sql-index-maintenance">
    Scheduled index rebuilding beyond the one-click Update Statistics button.
  </Card>

  <Card title="Database parameters" icon="database" href="/docs/administration/database/database-parameters">
    Change the underlying database connection itself.
  </Card>
</CardGroup>