Documentation Center

Creating a Microsoft SQL Server Content Data Store database manually

Create your SQL Server Content Data Store database manually by running the database scripts provided.

Procedure

  1. Close all connections to your Microsoft SQL Server database server.
  2. Access your SDL Tridion installation media.
  3. Navigate to the folder Database\Scripts\MSSQL\Create\ and run the following scripts:
    • CD_BROKER_CREATE.sql
    • CD_BROKER_TABLES.sql
    • CD_BROKER_CONSTRAINTS.sql
    • CD_BROKER_INDEXES.sql
    • CD_BROKER_DATA.sql
    • CD_WAI_TABLES.sql
    • CD_WAI_CONSTRAINTS.sql
    • CD_WAI_INDEXES.sql
  4. Navigate to the folder Database\Scripts\MSSQL\Shared\71\ and run the following script\:
    • 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.