Documentation Center

Creating Archiver database on Microsoft SQL Server manually

If, for whatever reason, you wish to create your Archiver database without running the PowerShell scripts, you can run SQL scripts manually instead. The scripts must be run by a properly authorized user (that is, a user who can create databases, tables etc).

Procedure

  1. On the installation media, browse to Database\Scripts\MSSQL\.
  2. In the Create\ subfolder, run the following scripts:
    • TAM_CREATE.sql
    • TAM_DATA.sql
    • TAM_TABLES.sql
    • TAM_CONSTRAINTS.sql
    • TAM_INDEXES.sql
  3. In the Shared\10SP3\ subfolder, run the script TAM_SET_VERSION.sql.