Create your Microsoft SQL Server publish undo database manually by running database scripts that create the database and its tables.
Procedure
- Close all connections to your Microsoft SQL Server database server.
- Access your SDL Web installation media.
- Navigate to the folder Database\Scripts\MSSQL\Create\.
- 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.
- 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
- 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
- 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:
Results
You have created the publish undo database.