n 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.
To use SQL Server Management Studio to manage your Orion Platform
database:
1. Click Start > Microsoft SQL Server > SQL Server Management Studio.
2. Click View > Object Explorer.
3.
Expand the SQL Server instance containing your Orion Platform database in the
Object Explorer pane on the left.
Note: Expand the Databases folder for any instance to confirm included
databases. By default, the Orion Platform database is named SolarWinds.
4.
Expand the Management folder, right-click the Maintenance Plans folder, and
then click Maintenance Plan Wizard.
5. Click Next to start the SQL Server Maintenance Plan Wizard.
6. Provide an appropriate Name and Description for your maintenance plan.
7. Click Browse (...) next to the Server field.
8.
Check your SQL Server\Instance, and then click OK.
Note: If your SQL Server\Instance is not in the list, provide it manually.
9.
Select the authentication type that is used to connect to the SQL server, and, if
required, provide appropriate User name and Password credentials.
10.
Note: Use the same authentication type and credentials you provided in the
Orion Configuration Wizard to access your Orion Platform database.
11.
Check Clean Up History and Back Up Database (Full)
Note: When a task is clicked, the Maintenance Plan Wizard provides a brief task
description.
12. Click Next.
13.
Set the order of task execution, top to bottom, by selecting tasks and clicking
Move Up and Move Down as needed.
Note: The following steps assume the Clean Up History task precedes the Back
Up Database (Full) task.
14. Click Next when the task execution order is set.
321
Using SQL Server Management Studio
To Next Page
Loading...