Accruent Meridian Enterprise 2020 Administrator's Guide

Create the Vault Database Manually

By default, Meridian creates the SQL Server database for a vault automatically during vault creation as described in Create a New Vault. If this is impractical for your organization, a database administrator can create the database in advance of creating the vault.

To create a vault database manually:

  1. Direct a database administrator to create a new SQL Server database with the following requirements:

    • The database name must be the same as the expected vault name and can contain any valid characters.
    • The INDEX_FILES filegroup must exist in the database.
    • The .mdf file must be named <VaultName>_Data.mdf.
    • The .ndf file must be named <VaultName>_Index.ndf and must be created in the filegroup INDEX_FILES.
    • The .ldf file must be named <VaultName>_Log.ldf.
  2. If the default backup location will be used, create a sub-folder named Backup in the database folder.
  3. Proceed by creating the vault as described in Create a New Vault and specify the same name for the vault as was used to create the database in step 1. Also select the Database exists option.