Home > Success Center > User Device Tracker (UDT) > UDT Administrator Guide > Manage the SolarWinds UDT Database > Use SQL Server Management Studio

Use SQL Server Management Studio

Table of contents
No headers
Created by Steven Bansil, last modified by Steven Bansil on Feb 02, 2017

Views: 82 Votes: 0 Revisions: 2

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.

  • Your specific environment may require additional configuration.
  • You may need to contact your database administrator to gain access to SQL Server Management Studio for your Orion Platform database.

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.

  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.

    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.

    If your SQL Server\Instance is not in the list, you need to 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.
    Use the same authentication type and credentials you provided in the Orion configuration wizard to access your Orion Platform database.
  10. Check Clean Up History and Back Up Database (Full)

    When a task is clicked, the Maintenance Plan Wizard provides a brief task description.

  11. Click Next.
  12. 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.

  13. Click Next when the task execution order is set.
  14. On the Define Cleanup History Task view, check the types of historical data to delete, and then set the threshold age for historical data removal.
  15. Click Next.
  16. On the Database Back Up (Full) view, complete the following steps:

    1. Click the Databases field.
    2. Select These databases.
    3. Check your Orion Platform database.
  17. Click OK.
  18. Select Database in the Backup component area.
  19. In the Destination area, complete the following steps:

    1. Select Disk.
    2. Select Create a backup file for every database.
    3. Click Browse (...) to select an appropriate database backup file destination with sufficient free space.
  20. Click Next.
  21. On the Select Plan Properties view, click Change.
  22. Configure the database maintenance job schedule as follows:

    1. Provide an appropriate Name for the new job schedule.
    2. Select Recurring as the Schedule type.
    3. Check Enabled, and then select Daily in the Occurs field.
    4. Provide an off-peak network usage time in the Occurs once at field.
    5. Select a Start date, and then select No end date.
  23. Click OK.
  24. Click Next, and then check Write a report to a text file.
  25. Click Browse (...) to select an appropriate maintenance report file destination.
  26. Review wizard results, click Finish, and then, when the wizard successfully finishes, click Close.

For additional help with using SQL server Management Studio, visit the Microsoft Support website.

 
You must to post a comment.
Last modified
01:23, 2 Feb 2017

Tags

Classifications

Public