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.
- In the Recovery model field, select: Full
Note:
The Full Recovery model uses database backups and transaction log backups to provide complete protection against media failure. If one or more data files are damaged, media recovery can restore all committed transactions. In-process transactions are rolled back. It provides you with the ability to recover the database to the point of failure or to a specific point in time. To guarantee this degree of recovery, all operations, including bulk operations such as SELECT INTO, CREATE INDEX, and bulk loading data, are fully logged. The recovery model may be set to Simple to avoid a fast growing transaction log files, but note that this reduces the number of points-in-time for recovery.
- In the Compatibility level field:
- If installing on SQL Server 2012 enter: SQL Server 2012 (110)
- If installing on SQL Server 2014 enter: SQL Server 2014 (120)
- Click OK.