Skip to main content
Search Again

We think these articles could help you:

    See More
    Nintex Knowledge Base

    Nintex Workflow Task Resume After SQL Server Migration

    Status: Validated

    QUESTION
    After migrating SQL databases to a new server, and changing the SQL alias, will the in-progress and running Nintex workflow instance automatically resume on the new SQL server?
    ANSWER
    When creating a task in Nintex workflow, the task data is saved in two places:
    • SharePoint content database (used by the SiteCollection)
    • 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.

    For more information, see Moving databases to a new server.
    ADDITIONAL INFORMATION
    RELATED LINKS
    • Was this article helpful?