Creating a database
Create a database for the Content Manager data collection.
Procedure
- Open SQL Server Management Studio.
- Right-click on Databases then click New Database…
- Enter a database name (e.g.
ContentManager). - Click Options in the left pane.
- In the Collation field, select: SQL_Latin1_General_CP1_CI_AS.
- 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.
Note: The recovery model determines the number of transactions logged for later system recovery. Whereas a Full model provides the best security with a higher points-in-time for recovery, in some situations a Full model may cause logs to grow beyond system's ability to process them. Check your database documentation for more information. - In the Compatibility level field:
- If installing on SQL Server 2016 enter: SQL Server 2016 (130)
- If installing on SQL Server 2017 enter: SQL Server 2017 (140)
- Click OK.