This article explains the necessary steps to execute in OutSystems Platform Server when you need to restore the database to a new server.
It does not cover the necessary steps to execute on the database. For detailed instructions on how to backup and restore the database, please refer to the documentation of your database management system.
To apply this procedure, the following requirements must be met:
Have an on-premises installation in .NET stack.
The Platform Server version is 8.0 or higher.
The old database server being replaced hosts only the database.
It is advisable that you keep the old database server running until the operation is complete, in case you need to rollback.
Step 1. Prepare for the restoring process
Start the process by backing up the old database and restoring it to the new database server:
Prepare the new database server by executing the steps of the installation checklist (Task: First Install, Role: Database).
Stop the IIS and the OutSystems Services in all front-ends.
Back up the old database.
Restore the backup to the new database server.
Step 2. Update the OutSystems application servers to use the new database server
After restoring the database to the new database server, you need to run the Configuration Tool in all the OutSystems application servers.
In farm environments, start by executing the steps below in the deployment controller server, and then repeat the same steps for each front-end server.
In each application server, execute the following steps:
Open the Configuration Tool.
Confirm the database connection details in Database and tabs, and change them if necessary.
Click Apply and Exit.
When prompted to run Service Center installation, answer No.
When prompted to restart OutSystems Services, answer Yes.
Start IIS and ensure all OutSystems Services are running.
Step 3. Decommission the old database server
After making sure that everything is working as expected, you can decommission the old database server.