Managing the SolarWinds UDT Database
15.
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.
16. Click Next.
17.
On the Database Back Up (Full) view, complete the following steps:
a. Click the Databases field.
b. Select These databases.
c. Check your Orion Platform database.
18. Click OK.
19. Select Database in the Backup component area.
20.
In the Destination area, complete the following steps:
a. Select Disk.
b. Select Create a backup file for every database.
c. Click Browse (...) to select an appropriate database backup file
destination with sufficient free space.
21. Click Next.
22. On the Select Plan Properties view, click Change.
23.
Configure the database maintenance job schedule as follows:
a. Provide an appropriate Name for the new job schedule.
b. Select Recurring as the Schedule type.
c. Check Enabled, and then select Daily in the Occurs field.
d. Provide an off-peak network usage time in the Occurs once at field.
e. Select a Start date, and then select No end date.
24. Click OK.
25. Click Next, and then check Write a report to a text file.
26. Click Browse (...) to select an appropriate maintenance report file destination.
27. 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 at http://support.microsoft.com.
322
To Next Page
Loading...