Map databases
This article provides answers to frequent questions about mapping Nintex Workflow and SharePoint content databases.
Do I need a Nintex content database for every SharePoint site collection using Nintex Workflow?
In many cases we recommend a 1-to-1 mapping, where each Nintex Workflow content database is mapped to a SharePoint content database. However, if you have over 25 SharePoint content databases, you may choose to map databases by department or other grouping. For guidance on planning database mapping and maintenance, see Design databases.
Do mapped databases need to be backed up simultaneously?
Yes. For details, see Backup and restore databases.
How do I split an existing Nintex content database?
You can split Nintex content databases using the NWAdmin operation MoveData. For instructions on how to implement a 1-to-1 mapping for an existing site collection already using Nintex Workflow, see Split databases.
How do I split an existing SharePoint content database?
You can split SharePoint content databases using the Windows PowerShell command Move-SPSite. For instructions on how to implement a 1-to-1 mapping for an existing site collection already using Nintex Workflow, see Split databases.
What happens if we run workflows before content databases are mapped?
If automatic mapping is enabled, then the system automatically maps the affected SharePoint content database to an available Nintex Workflow content database. If automatic mapping is disabled, then the workflow will not run successfully until the mapping is specified by the administrator.
How do I disable automatic mapping for content databases?
You can disable automatic database mapping using the Manage database mappings page accessed from Central Administration. Automatic database mapping is enabled by default. For more information about this page, see the product help.
Can I change the Nintex Workflow content database later?
Yes. You can either change the mapping for new site collections only or for both existing and new site collections.
To change the mapping for new site collections only, select a different Nintex Workflow content database using the related management pages accessed from Central Administration. The original mapping is retained for any site collections on the SharePoint content database that have already started storing workflow progress data.
To change the mapping for both existing and new site collections on a given SharePoint content database, use the NWAdmin operation MoveData. This operation moves existing workflow progress data to a different Nintex Workflow content database. Using this operation is helpful when you want to keep all site collection data together. For instructions on how to implement a 1-to-1 mapping for an existing site collection already using Nintex Workflow, see Split databases. For more information on the MoveData operation, see NWAdmin Guide.