Steps for migrating the SQL database to another server?

People,

As per https://documentation.solarwinds.com/en/success_center/orionplatform/Content/System_Requirements/Orion_Platform_2020-2_system_requirements.htm

The SQL database for the Polling Engine must be separately located in two different VMs.

May I know what are the steps that I can follow to migrate the Solarwinds Polling Engine SQL Server to another VMs running SQL server?

Thank you in advance.

Find more posts tagged with

Accepted answers

All comments

sum_giais

Here’s where you can get started assessing your requirements. In simplest form... you stop the Orion services, take a database backup, restore that backup to your new sql server and run the configuration wizard pointing Orion to your new sql server. Obviously there’s more steps involved depending on your environment, Orion versions and products you’re running but that is the rough process. Below are the guides from SolarWinds.

https://documentation.solarwinds.com/en/Success_Center/orionplatform/Content/Orion_Platform_Migration_Guide.htm

https://documentation.solarwinds.com/en/Success_Center/orionplatform/Content/Migrate_the_SolarWinds_Orion_SQL_database_to_a_new_server.htm

itengineer

hi, @sum_giais Thank you for the confirmation.

After the SQL server DB .MDF and .LDF has been migrated off to another VM, can I completely uninstall any or all SQL server components in the main polling engine?

sum_giais

My gut says yes at least for the main sql install but I’ve never had Orion and sql running on the same server before so I’d just be cautious there not to remove any required components.

itengineer

Yes, that's what I'd like to know, so I can remove the unused SQL server components in this existing Main Polling Engine.
Also to reduce the SQL server cost.