This article provides answers to frequent questions about mapping Nintex Workflow and SharePoint content databases.
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.
Yes. For details, see Backup and restore databases.
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.
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.
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.
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.
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.