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:
- In the Name field, type StratusMaintenancePlan.
- 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:
- In the Occurs drop-down list select Daily.
- Set Recurs every: to 1 day.
-
In the
Daily frequency section do the following:
- Select Occurs once at:
- 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:
- Start Date is today's date.
- 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:
-
Click the
Databases drop-down list.
A dialog box opens.
-
Select
These databases and select the following
from the list:
- ISDB
- MediaFlow
- MediaFrame
- RulesEngine
- Click OK to save settings and close the dialog box.
- On the Define Database Check Integrity Task page, select Include indexes.
- Click Next.
-
Click the
Databases drop-down list.
A dialog box opens.
-
On the Define Shrink Database Task page, do the following:
-
Click the Databases drop-down list, and select the
following:
- ISDB
- MediaFlow
- MediaFrame
- RulesEngine
- Click OK.
- Set Shrink database when it grows beyond: to 100 MB. Leave other settings at the default configuration.
- Click Next.
-
Click the Databases drop-down list, and select the
following:
-
On the Define Rebuild Index Task page, do the following:
-
Click the Databases drop-down
list, and select the following:
- ISDB
- MediaFlow
- MediaFrame
- RulesEngine
- Click OK. Leave other settings at the default configuration.
- Click Next.
-
Click the Databases drop-down
list, and select the following:
-
On the Define Update Statistics Task page, do the following:
-
Click the Databases drop-down
list, and select the following:
- ISDB
- MediaFlow
- MediaFrame
- RulesEngine
- Click OK. Leave other settings at the default configuration.
- Click Next.
-
Click the Databases drop-down
list, and select the following:
-
On the Define Back Up Database (Full) Task page, do the following:
-
Click the Databases drop-down
list, and select the following:
- ISDB
- MediaFlow
- MediaFrame
- RulesEngine
- Click OK.
- Select Create a backup file for every database.
- In the Folder field, enter the path to your site's database backup location. Leave other settings at the default configuration.
- Click Next.
-
Click the Databases drop-down
list, and select the following:
-
On the Define Maintenance Cleanup Task page, do the following:
- In the File age section, set Delete files older than the following: to 1 week. Leave other settings at the default configuration.
- Click Next.
- 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.