Creating a Microsoft SQL Server database for Content Manager

Create a database for the Content Manager data collection.

Procedure

  1. Open SQL Server Management Studio.
  2. Right-click on Databases then click New Database…
  3. Enter a database name (e.g. ContentManager).
  4. Click Options in the left pane.
  5. In the Collation field, select: SQL_Latin1_General_CP1_CI_AS.
  6. Select the appropriate Recovery model.
    • Full: All transactions are logged. The recommended choice for production databases.
    • Simple: A portion of the transactions are logged. A choice for some test or development databases.
    • Bulk-Logged: temporary setting used for specific large-scale bulk operations.
  7. In the Compatibility level field, select option corresponding to the version of SQL Server you are using.
  8. Click OK.