Grass Valley GV STRATUS Installation v.3.1 - Manual (Page 303)

19. On the Define Maintenance Cleanup Task page, do the following:
a) In the File age section, set Delete files older than the following: to 1 week.
Leave other settings at the default configuration.
b) Click Next .
The Select Report Options page opens.
20. On the Select Report Options page, leave settings at the default configuration. Click Next .
The Complete the Wizard page opens.
21. On the Complete the Wizard page, click Finish .
The Maintenance Plan Wizard Progress page opens and reports progress.
22. When the page reports success for all actions, click Close .
The GV STRATUS maintenance plan is created.
Before continuing with other database maintenance plan operations, close and re-open Microsoft
SQL Server Management Studio.
Next, verify the database maintenance plan status.
Verifying the database maintenance plan status
1. Open and log in to Microsoft SQL Server Management Studio.
2. In the tree-view, open the Management | Maintenance Plans nodes.
3. Right-click on a plan and select View History .
The Log File Viewer window opens.
4. View the status report.
If an error occurs, it is likely that the SQL Server Agent is not started. Start the service and start
over.
Testing the backup
Before doing this task, verify that logging is turned off for IIS.
Database performance can be downgraded while this test is in progress, but the database remains
operational during the test.
1. Open and log in to Microsoft SQL Server Management Studio.
2. In the tree-view, open the Management | Maintenance Plans nodes.
3. Right-click on a plan and select Execute .
the Execute Maintenance Plan dialog box opens and reports progress.
4. To check for errors, view the history.
Modifying the maintenance plan backup location
Maintenance plans automate database tasks necessary to ensure database integrity and recovery in
case of data loss.
2013 12 19 GV STRATUS Installation and Service Manual 303
Administering and maintaining the GV STRATUS system