Grass Valley Aurora Browse v.6.5 Installation - Manual (Page 106)

106 Aurora Browse Installation and Configuration Guide November 1, 2008
Chapter 4 Recovery Planning
Modifying the maintenance plan schedule
The backup should occur at a time that does not conflict with peak usage of the
system. The pre-configured maintenance plan schedules the backup for 1:30 a.m. If
this schedule conflicts with your system usage patterns, use the following procedure
to modify the schedule:
1. Open the Windows operating system Services control panel and verify that the
SQLSERVERAGENT service is set to start automatically and that it is currently
running.
2. Open Microsoft SQL Server Management Studio and log in with the appropriate
credentials. To create or manage maintenance plans, you must be a member of the
sysadmin fixed server role.
Server Management Studio opens.
3. In Management Studio Object Explorer, expand the node for the MediaFrame
server, expand Management , and then expand Maintenance Plans .
4. Right-click MediaFrame Maintenance Plan , and click Modify .
A Plan Design panel opens.
5. In the Plan Design panel list, select one of the following subplans:
• weekly_maintenance
• daily_maintenance
6. With the subplan selected, click Subplan Schedule in the toolbar.
The Job Schedule Properties dialog box opens
7. In the Job Schedule Properties dialog box, enter the new schedule details.
8. Click OK on the Job Schedule Properties dialog box.
9. Repeat preceding steps as necessary to modify the other subplan schedule.
10.Close Server Management Studio and answer Yes when prompted to save changes.
Restoring the MediaFrame server database
If your MediaFrame server is correctly running the database maintenance plan, the
database backup files allow you to restore the database. You should only need to
restore the database if a catastrophic system failure occurs and you lose the database.
To restore the database, you must accomplish tasks such as restoring the full backup,
restoring each subsequent differential backup, restoring the tail-log, and recovering
the database. Only database administrators or persons with similar experience and
knowledge should attempt to restore the MediaFrame server database. Based on your
modifications to the database maintenance plan and the time the system failure
occurred, a database administrator can refer to Microsoft SQL Server procedures as
necessary and determine the proper steps. If you need help with this, contact Grass
Valley Support.