Grass Valley GV STRATUS Installation v.3.1 - Manual (Page 292)

Database planning and maintenance strategies
The topics in this section help you establish a plan in the event a GV STRATUS system fails.
Core Services server failure considerations
The GV STRATUS Core 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 SQL Server Agent service is ever stopped, so is your maintenance plan. Make sure that the
service is set to start automatically.
A Fault Tolerant (FT) server is available from Grass Valley to further protect the integrity of the
system.
Logging in to Microsoft SQL Server Management Studio
If directed by a documented procedure or by Grass Valley Support, you can view and make SQL
database settings in Microsoft SQL Server Management Studio.
1. Make sure you are logged in to the database host system with Administrator privileges.
2. Open the Windows operating system Services control panel and verify that the SQL Server Agent
service startup type is set to automatic and that it is started.
3. From the Windows desktop click Start | All Programs | Microsoft SQL Server 2008 R2 and select
Microsoft SQL Server Management Studio .
Microsoft SQL Server Management Studio opens.
4. Log on and connect to your SQL Server as follows:
• Server type: Database Engine
• Server name: (local)
• Authentication: Windows Authentication
5. Identify the databases that are a part of the GV STRATUS system, which include the following:
• ISDB
• MediaFlow
• MediaFrame
• RulesEngine
• WfPersistence
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,
292 GV STRATUS Installation and Service Manual 2013 12 19
Administering and maintaining the GV STRATUS system