Previous Topic: SQL Server: Post-Upgrade Table Change

Next Topic: Install the SPs Into Your Database

Back up Your CMS Database

You must back up your CMS database before modifying the Wgn3EventParticipant table. You will also need to back it up again after modifying the table to create a new restore point.

In particular, be aware that the database recovery model will be switched to BULK_LOGGED mode while the participant records are restored (step 7 in Run the "modify table" script). As a consequence, any table backups that predate the modification will not be usable if you need to restore the table in the future.

After backing up your CMS, you are ready to install the necessary stored procedures; see the next section.

More information:

Run the Modify Table Script

Install the SPs Into Your Database