Skip to main content

 

 

 

 

Template:OutSystems/Documentation_KB/Breadcrumb_New_Layout

 

 

Template:OutSystems/OSLanguageSwitcher

 

 

 

OutSystems

Restore OutSystems database to a different DB Server

This article explains the necessary steps to execute in OutSystems Platform Server when you need to restore the database to a new server.

It doesn't 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.

Prerequisites

To apply this procedure, the following requirements must be met:

  • Have an on-premises installation in .NET stack.

  • The old database server replaced hosts only the database.

  • The database was on server A and will be moved to server B.

  • The database remains intact, without alterations to the data or database users.

  • No changes will be done to the application servers.

If you are looking to create a copy of an existing environment while maintaining the original environment, check this article instead.

It is advisable that you keep the old database server running until the operation is complete, in case you need to rollback.

Restoring Process

Step 1. Prepare for the restoring process

Start the process by backing up the old database and restoring it to the new database server:

  1. Prepare the new database server by executing the steps of the installation checklist (Task: First Install, Role: Database).

  2. Stop the IIS and the OutSystems Services in all front-ends.

  3. Back up the old database.

  4. 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.

For OutSystems 10

In each application server, execute the following steps:

  1. Open the Configuration Tool.

  2. Confirm the database connection details in Database and tabs, and change them if necessary.

  3. Click Apply and Exit.

  4. When prompted to run Service Center installation, answer No.

  5. When prompted to restart OutSystems Services, answer Yes.

  6. Start IIS and ensure all OutSystems Services are running.

For OutSystems 11

In each application server, execute the following steps:

  1. Open the Configuration Tool.

  2. Confirm the database connection details in Database and tabs, and change them if necessary.

  3. Start IIS.

  4. Click Apply and Exit.

  5. When prompted to run Service Center installation, answer Yes.

  6. When prompted to restart OutSystems Services, answer Yes.

  7. Ensure all OutSystems Services are running.

  8. Create a solution with all the modules and click Apply settings

Step 3. Decommission the old database server

After making sure that everything is working as expected, you can decommission the old database server.

  • Was this article helpful?