Grass Valley Aurora Browse v.7.0 Installation - Manual (Page 148)

148 Aurora Browse Installation and Configuration Guide April 6, 2010
Chapter 6 Database and Recovery Planning
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 the weekly_maintenance subplan.
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. 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.
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.
Updating the maintenance plan after renaming the server
If you rename the MediaFrame server, you must update the maintenance plan.
Renaming the server does not alter the maintenance plan.
Before updating the maintenance plan, verify that you have has SQL Server
Integration Services (SSIS) installed. SSIS is part of the typical SQL Server
installation.
The maintenance plan update can be divided into three main sections:
• Stage 1: Exporting the maintenance plan to a file
• Stage 2: Updating the file with the new server name
• Stage 3: Importing the modified plan
To update the maintenance plan, follow these steps:
1. Open SQL Server Management Studio (SSMS) on the server.