Database Maintenance
Six command-line maintenance utilities are available for the News database used by
Aurora Edit, Aurora Playout, and NewsShare. These utilities are automatically installed
on DNP client machines and most NewsShare servers in the C:\Program Files\Grass
Valley\Aurora\DB Maintenance directory. They can also be installed from the Aurora
Suite CD.
The following utilities are covered in this section:
Description
Name
Backs up the News database
newsBackUpDb
Restores the database from a backup
newsRestoreDb
Removes the database (for complete uninstall)
newsDropDb
Recreates an empty News database
newsInstallDb
Shrinks the database
newsShrinkDb
Schedules automatic backups of the News database
newsInitAutoBack
NOTE: Use these utilities with great care. The restore and drop commands,
respectively, overwrite and delete existing databases such that current data will be
lost.
Database Overview
This section gives an overview of using database utilities.
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.
140
Aurora Edit Installation Guide
4 October 2010
Database Maintenance
