To exchange the database server used by SharePoint, you habe to do the following steps:
- Make a full backup via SharePoint Central Administration.
- Use the "SharePoint Products and Technologie Configuration Wizard" to disjoin every single SharePoint Server from the SharePoint farm.
- Use the "SharePoint Products and Technologie Configuration Wizard" to create a NEW farm (wich means you create a new SharePoint Configuration database) and take the new database server for configuration settings.Join every single Server to the SharePoint farm.
- Restore the full backup via CentralAdministration in the SharePoint Farm.
After this, you have to update the internal reference of the Content DBs to the new server. This you can do with the nwadmin tool. You find this tool under the path C:\Program Files\Nintex\Nintex Workflow 2007\ in standard installations.
You have to run the following command line:
NWAdmin.exe -o UpdateContentDatabase -serverName serverName [-databaseName databaseName] [-newServerName newServerName] [-newDatabaseName newDatabaseName] [-integrated
-username username -password password]
Run this command line in the cmd and replace the parameters with you own values. After runing this command line, the references of your Nintex Databases will be updated.
Further information about UpdateContentDatabase operation with all parameters or and other nwadmin operations you can find in this pdf.