Creating a Microsoft SQL Server publish undo database manually

Create your Microsoft SQL Server publish undo database manually by running database scripts that create the database and its tables.

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 publish undo database.