If you have a licensed, Standard or Enterprise Edition copy of SQL Server 2005, 2008 or 2012 with SQL Server Management Studio installed, you can use it to maintain your SolarWinds UDT database. The following procedure is a basic guide to configuring a daily Orion Platform database maintenance plan in SQL Server Management Studio.
The following procedure clears historical maintenance records and creates a backup of your Orion Platform database. In general, however, SolarWinds recommends that you contact your database administrator and reference the Microsoft documentation provided with SQL Server for instructions on using SQL Server Management Studio to manage your Orion Platform database.
Expand the SQL Server instance containing your Orion Platform database in the Object Explorer pane on the left.
Expand the Databases folder for any instance to confirm included databases. By default, the Orion Platform database is named SolarWinds.
Check your SQL Server\Instance, and then click OK.
If your SQL Server\Instance is not in the list, you need to provide it manually.
Check Clean Up History and Back Up Database (Full)
When a task is clicked, the Maintenance Plan Wizard provides a brief task description.
Set the order of task execution, top to bottom, by selecting tasks and clicking Move Up and Move Down as needed.
The following steps assume the Clean Up History task precedes the Back Up Database (Full) task.
On the Database Back Up (Full) view, complete the following steps:
In the Destination area, complete the following steps:
Configure the database maintenance job schedule as follows:
For additional help with using SQL server Management Studio, visit the Microsoft Support website.