References > Aliases > Maintain the SolarWinds Orion database > Back up and restore the database

Back up and restore the database

Use the SQL Server Management Studio to create and restore backups on your servers. The application should be installed with the Microsoft SQL Server. You typically will manage backups when performing SolarWinds product upgrades, migrating to a new server, or as part of a maintenance schedule.

See the Microsoft Support page for information about creating backups with your version of the MS SQL Studio.

After performing a restore, you will need to update the database location through the console.

While restoring the database, use the Restore with Recovery option.

For more information, search for "restore a database backup" on the Microsoft TechNet web portal at https://technet.microsoft.com, and consult the help for the appropriate SQL Server Management Studio version.