Topic
After migrating SQL databases to a new server, and changing the SQL alias, will the "In-progress" Nintex Workflow instance automatically resume on the new SQL server?
Additional Information
When creating a task in Nintex workflow, the task data is saved in two places:
- SharePoint content database (used by the Site Collection)
- Nintex content database
When the SharePoint workflow engine attempts to resume the workflow, it will look for task data from both databases. If these two databases are migrated to a new SQL server in sync, the Nintex workflow instance will resume. If they are not migrated in sync, the task data will not be synchronized and the instance will fail to start.
Related Links