beautypg.com

Overview, Newsbackupdb, Overview newsbackupdb – Grass Valley Aurora Edit LD v.6.5 Installation User Manual

Page 104

background image

90

Aurora Edit Installation Guide

November 25, 2008

Appendix B Database Maintenance

Overview

When used, the utilities must be run from the C:\Program Files\Grass Valley\Aurora\DB

Maintenance directory of the machine whose database is being operated upon. The user

must be a member of the system’s Administrators group. For a local, stand-alone

machine, run the utilities at that workstation. For the central News database of a shared

storage system (NewsShare), run the utilities at the DSM.
To run any of the utilities, open a command window and type the command. The

following sections describe each utility and its usage. Note that filenames used in the

commands must be fully qualified.
Before running any of the utilities, follow these preparatory steps:
• For restore and drop operations, the News database must not be servicing clients.

Close all DNP applications that would use it.

• For DSM-based News databases, observe these constraints:

• Back up the database from the primary DSM.

• If automatic database backups are scheduled, they must be set to occur during

periods of extremely low system utilization, preferably when zero NewsShare or

are recording or playing clips.

• Stop all access before restoring or dropping the database.

• Take DSMs out of service before restoring or dropping the database.

• Close all SQL applications before restoring or dropping the database.

• Restore the database to the primary DSM.

newsBackUpDb

Template

newsBackUpDb

Example

C:\Program Files\Grass Valley\Aurora\DB Maintenance>
newsBackUpDb c:\backups\news.dat

Backing up this machine's News 4.1+ database to location
c:\backups\news.dat

. . .

Contents of log file vNewsBackUpDb.log:

---------------------------------------------------------

Tue 11/26/2002

4:38p

Administrator

Backing up news DB from VMAN_VBRFSM3 to file
c:\backups\news.dat.

This manual is related to the following products: