Upgrading your State Store Microsoft SQL Server database

P erform these steps to upgrade the State Store database.

Procedure

  1. Back up your database.
  2. Access your Tridion Docs 14 installation media.
  3. E xecute the following SQL scripts:
    
    \Database\Scripts\MSSQL\Shared\101\DP_STATE_SET_VERSION.sql
    \Database\Scripts\MSSQL\Shared\1011\DP_STATE_SET_VERSION.sql
    \Database\Scripts\MSSQL\Shared\110\DP_STATE_SET_VERSION.sql
  4. Regardless of the release from which you are upgrading, execute the following SQL scripts:
    \Database\Scripts\MSSQL\Shared\111\DP_STATE_SET_VERSION.sql
    \Database\Scripts\MSSQL\Shared\CREATE_FK_INDEXES.sql