Creating a Microsoft SQL Server database for Content Manager
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, select option corresponding to the version of SQL Server you are using.
- Click OK.