Other Topic Library Versions

Creating the GV STRATUS maintenance plan

Maintenance plans automate database tasks necessary to ensure database integrity and recovery in case of data loss.

If you moved the GV STRATUS database to a new/different server machine, you have to create the GV STRATUS maintenance plan on the particular machine separately.

Grass Valley recommends that the database backup location be network storage, preferably one that is backed up or has some kind of RAID protection. If the database is backed up to a network share, the account under which SQL Server (MSSQLSERVER) and SQL Server Agent (MSSQLSERVER) run must have permission to write to the network share. If these services are running a virtual Network Service or NT Service\MSSQLSERVER account, then the network share must have permission for the computer account (e.g., yourDomain\StratusCoreServer$).

To create or manage maintenance plans, you must log in as a member of the sysadmin fixed server role.

  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 the Maintenance Plans node a select Maintenance Plan Wizard. The Maintenance Plan Wizard opens.
  4. On the Maintenance Plan Wizard, click Next. The Select Plan Properties page opens.

  5. On the Select Plan Properties page do the following:
    1. In the Name field, type StratusMaintenancePlan.
    2. Select Single schedule for the entire plan or no schedule
  6. Click Change. The Job Schedule Properties dialog box opens.

  7. In the Frequency section do the following:
    1. In the Occurs drop-down list select Daily.
    2. Set Recurs every: to 1 day.
  8. In the Daily frequency section do the following:
    1. Select Occurs once at:
    2. Accept the default time of 12:00:00 AM or change it to a time more suitable to your site.
  9. In the Duration section, verify the following:
    1. Start Date is today's date.
    2. No end date is selected.
  10. Click OK and Next. The Select Maintenance Tasks page opens.

  11. Select the following:
    • Check Database integrity
    • Shrink Database
    • Rebuild Index
    • Update Statistics
    • Back Up Database (Full)
    • Maintenance Cleanup Task
  12. Click Next. The Select Maintenance Task Order page opens.
  13. On the Select Maintenance Task Order page, leave settings at the default configuration. Click Next. The Define Database Check Integrity Task page opens.

  14. On the Define Database Check Integrity Task page, do the following:
    1. Click the Databases drop-down list. A dialog box opens.

    2. Select These databases and select the following from the list:
      • ISDB
      • MediaFlow
      • MediaFrame
      • RulesEngine
      • WfPersistence
    3. Click OK to save settings and close the dialog box.
    4. On the Define Database Check Integrity Task page, select Include indexes.
    5. Click Next.
    The Define Shrink Database Task page opens.

  15. On the Define Shrink Database Task page, do the following:
    1. Click the Databases drop-down list, and select the following:
      • ISDB
      • MediaFlow
      • MediaFrame
      • RulesEngine
      • WfPersistence
    2. Click OK.
    3. Set Shrink database when it grows beyond: to 100 MB. Leave other settings at the default configuration.
    4. Click Next.
    The Define Rebuild Index Task page opens.

  16. On the Define Rebuild Index Task page, do the following:
    1. Click the Databases drop-down list, and select the following:
      • ISDB
      • MediaFlow
      • MediaFrame
      • RulesEngine
      • WfPersistence
    2. Click OK. Leave other settings at the default configuration.
    3. Click Next.
    The Define Update Statistics Task page opens.

  17. On the Define Update Statistics Task page, do the following:
    1. Click the Databases drop-down list, and select the following:
      • ISDB
      • MediaFlow
      • MediaFrame
      • RulesEngine
      • WfPersistence
    2. Click OK. Leave other settings at the default configuration.
    3. Click Next.
    The Define Back Up Database (Full) Task page opens.

  18. On the Define Back Up Database (Full) Task page, do the following:
    1. Click the Databases drop-down list, and select the following:
      • ISDB
      • MediaFlow
      • MediaFrame
      • RulesEngine
      • WfPersistence
    2. Click OK.
    3. Select Create a backup file for every database.
    4. In the Folder field, enter the path to your site's database backup location. Copy the folder path so you can paste it on the next page.
    5. In the Backup file extension field, enter bak as the file extension. Leave other settings at the default configuration.
    6. Click Next.
    The Define Maintenance Cleanup Task page opens.

  19. On the Define Maintenance Cleanup Task page, do the following:
    1. In the File location section, select Search folder and delete files based on an extension.
    2. In the Folder field, paste the path of your site's database backup location that you copied earlier.
    3. In the File extension field, leave it blank.
      Warning: Do not enter .bak as it prevents files from getting automatically deleted and quickly fills up the core’s C: drive without warning.
    4. In the File age section, select Delete files based on the age of the file at task run time.
    5. Set Delete files older than the following: to 1 week. Leave other settings at the default configuration.
    6. 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.


Copyright © 2018 Grass Valley Canada. All rights reserved. GV STRATUS 6.5 gvtp_20181001_01:18:31