Creating the GV STRATUS maintenance plan

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

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.

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

Open and log in to Microsoft SQL Server Management Studio.
In the tree-view, open the Management | Maintenance Plans nodes.
Right-click the Maintenance Plans node a select Maintenance Plan Wizard. The Maintenance Plan Wizard opens.
On the Maintenance Plan Wizard, click Next. The Select Plan Properties page opens.
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
Click Change. The Job Schedule Properties dialog box opens.
In the Frequency section do the following:
1. In the Occurs drop-down list select Daily.
2. Set Recurs every: to 1 day.
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.
In the Duration section, verify the following:
1. Start Date is today's date.
2. No end date is selected.
Click OK and Next. The Select Maintenance Tasks page opens.
Select the following:
- Check Database integrity
- Shrink Database
- Rebuild Index
- Update Statistics
- Back Up Database (Full)
- Maintenance Cleanup Task
Click Next. The Select Maintenance Task Order page opens.
On the Select Maintenance Task Order page, leave settings at the default configuration. Click Next. The Define Database Check Integrity Task page opens.
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
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.
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
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.
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
2. Click OK. Leave other settings at the default configuration.
3. Click Next.
The Define Update Statistics Task page opens.
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
2. Click OK. Leave other settings at the default configuration.
3. Click Next.
The Define Back Up Database (Full) Task page opens.
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
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. Leave other settings at the default configuration.
5. Click Next.
The Define Maintenance Cleanup Task page opens.
On the Define Maintenance Cleanup Task page, do the following:
1. In the File age section, set Delete files older than the following: to 1 week. Leave other settings at the default configuration.
2. Click Next.
The Select Report Options page opens.
On the Select Report Options page, leave settings at the default configuration. Click Next. The Complete the Wizard page opens.
On the Complete the Wizard page, click Finish. The Maintenance Plan Wizard Progress page opens and reports progress.
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.