Genpact Cora Knowledge Center

Support

Restore a Cora SeQuence Database

This information explains how to restore a database on the same environment, not how to migrate a database between environments.

  1. Stop all services and sites.
    • Active Directory Synchronization Service
    • Background Runtime Service
    • Administration
    • Flowtime
    • ProcessTOGO (if installed as a separate site)
  2. Restore the database onto the server.
  3. Verify that the database is attached.
  4. Delete the necessary service broker items from the backed up database, in the following order.
    1. Services
    2. Queues
    Use the Object Explorer Details window to multi-select.
  5. Run the following query to create a new service
    ALTER DATABASE SequenceDBName SET NEW_BROKER WITH ROLLBACK IMMEDIATE
  6. Run the following script to grant ownership to the SQL user used by on the database.
    ALTER AUTHORIZATION ON DATABASE::[SequenceDBName] to [SQL user];
  7. Restart all sites and services.