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

142 Aurora Browse Installation and Configuration Guide April 6, 2010
Chapter 6 Database and Recovery Planning
MediaFrame server failure considerations
The MediaFrame server must have a database maintenance plan in place. The
maintenance plan backs up the SQL database on a regular basis and stores it in a safe
location. In the case of server failure the database can then be restored to minimize
data loss.
If the SQLSERVERAGENT service is ever stopped, so is your maintenance plan.
Make sure that the service is set to start automatically.
If an off-line backup server is purchased it should be pre-configured to operate in the
system so in case of primary server failure, minimal time will be spent bringing up the
backup system. The backed up database could be restored to this backup server on a
regular basis.
Newer systems have redundant power supplies and mirrored disks to further protect
the integrity of the system.
Updating the database to the simple model
As of Aurora Browse 6.5.2, the MediaFrame database needs to be updated to the
simple model. If your database is not using the simple model, it needs to be updated
before you run the maintenance plan.
To update the database to the simple model, follow these steps:
1. On the MediaFrame server, open SQL Server Management Studio.
2. Connect with the administrator credentials.
3. Expand the left-hand tree view to
< machine name> Databases|MediaFrame .
4. Right click on MediaFrame and select Properties .
5. In the Select a page pane, select the Options page.
6. From the Recovery Model drop-down list, select Simple .
7. Verify that the rest of the settings match the following screenshot, and click
OK .