Restore a 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 Sequence 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 all service broker queues and services from the backed up database.
    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 Sequence on the Sequence database.
    ALTER AUTHORIZATION ON DATABASE::[SequenceDBName] to [SQL user];
  7. Restart all sites and services.