Sharepointless database overwrite

0

Hi Konrad,

you can restore a production database as a test database. We have done so multiple times at least without SharePoint integration. I don't have any experience in regards to this.

For the standalone version it would be:
1. Backup of Content, Attachment, Archive databases
2. Deactivation of workflow service
3. Restore using the existing database names, otherwise you will need to add the content database to the ContentDatbase table in the config database and add the content database to the workflow service using the "Tools for application management" from the setup.exe later.
3. If you used a different config database name in production, you need to replace the value with the test config database in the global parameters table of the restored databases.
4. Grant the users of the test environment access to the database, if necessary
5. Change the database type
https://community.webcon.com/forum/thread/366?page=1#m372
6. Restart workflow service and IIS
7. If the other environment uses different admin users, add one for the current environment using WEBCON BPS System Administrators.exe
8. Reindex database
9. Do other changes, like mail configuration, admins, constants, global privileges and so on.

I think that's all. If someone has any correction, feel free to post them.

Best regards,
Daniel