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 Web 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. If you changed the name of the database that the script created, edit the following scripts, changing the name cd_broker_db to your chosen name throughout:
    • CD_BROKER_TABLES.sql
    • CD_BROKER_CONSTRAINTS.sql
    • CD_BROKER_INDEXES.sql
    • CD_BROKER_CREATE_LOGIN.sql
    • CD_BROKER_ALTER_LOGIN.sql
    • CD_BROKER_CREATE_USER.sql
    • CD_WAI_TABLES.sql
    • CD_WAI_CONSTRAINTS.sql
    • CD_WAI_INDEXES.sql
  6. Run these scripts as a database administrator user (sa):
    • CD_BROKER_TABLES.sql
    • CD_BROKER_CONSTRAINTS.sql
    • CD_BROKER_INDEXES.sql
    • CD_BROKER_CREATE_LOGIN.sql
    • CD_BROKER_ALTER_LOGIN.sql (skip this script if you use the Microsoft Azure SQL Database hosting service).
    • CD_BROKER_CREATE_USER.sql
    • CD_WAI_TABLES.sql
    • CD_WAI_CONSTRAINTS.sql
    • CD_WAI_INDEXES.sql
  7. Navigate to the folder Database\Scripts\MSSQL\Shared\81\ 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 publish undo database.