This information explains how to restore a database on the same environment, not how to migrate a database between environments.
- Stop all Sequence services and sites.
- Active Directory Synchronization Service
- Background Runtime Service
- ProcessTOGO (if installed as a separate site)
- Restore the database onto the server.
- Verify that the database is attached.
- Delete all service broker queues and services from the backed up database.
Use the Object Explorer Details window to multi-select.
- Run the following query to create a new service
ALTER DATABASE SequenceDBName SET NEW_BROKER WITH ROLLBACK IMMEDIATE
- 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];
- Restart all sites and services.