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

April 6, 2010 Aurora Browse Installation and Configuration Guide 147
Modifying the database maintenance plan
4. In the MediaFrame Config tool, update any MDI running on the server.
5. On any other machines that access the MediaFrame server, update the
configuration to use the new server name.
Modifying the database maintenance plan
The following section is based on a database maintenance plan created using the steps
in
“Creating a simple maintenance plan” on page 143 .
Modifying the maintenance plan backup location
The pre-configured maintenance plan places database backup files in the following
location:
C:\MediaFrame\backup
If your site has a different location specified for database backup files, use the
following procedure to modify the location:
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. Double-click Backup Database Task .
A Backup Database Task dialog box opens.
6. In the Backup Database Task dialog box, in the Folder field, modify the backup
directory path.
NOTE: SQL can only see local drives and cannot see shared directories or disks
that are not native to the machine.
7. Click OK on the Backup Database Task dialog box.
8. Close Server Management Studio and answer Yes when prompted to save changes.
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