Creating a Microsoft SQL Server Content Data Store database manually

Only if you have a pressing reason to do so, create your SQL Server Content Data Store database manually by running the database scripts provided. In a demo or test environment, you can choose to create the State Store in the same database, by creating the State Store database tables as well. In a production environment, you can choose to create the State Store in its own database instead (for example, to improve performance), by running the State Store table creation commands separately.

Procedure

  1. Close all connections to your Microsoft SQL Server database server.
  2. Access your SDL Tridion Sites installation media.
  3. Navigate to the folder Database\Scripts\MSSQL\Create\.
  4. Create the database by running the script called CD_BROKER_CREATE.sql as a database administrator user (sa). By default, the script creates a database called cd_broker_db. To change this, edit the script to use a different name.
  5. Run these scripts as a database administrator user (sa):
    • CD_BROKER_TABLES.sql
    • CD_BROKER_CONSTRAINTS.sql
    • CD_BROKER_INDEXES.sql
  6. If you want to create the State Store database tables in this database, run the following scripts as a database administrator user (sa):
    • DP_STATE_TABLES.sql
    • DP_STATE_CONSTRAINTS.sql
    • DP_STATE_INDEXES.sql
  7. If you want to create the State Store database tables in this database, in the folder Database\Scripts\MSSQL\Shared\85\, run the following script as a database administrator user (sa):
    • DP_STATE_SET_VERSION.sql
  8. Navigate to the folder Database\Scripts\MSSQL\Shared\110\ and run the following script as a database administrator user (sa), again changing the database name if needed:
    • GENERAL_SET_VERSION.sql

Results

You have created the Content Data Store.

What to do next

When installing a Server Role, you configure the Content Data Store in the Storage Layer configuration file.