•
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 <backup file name>
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.
27 percent backed up.
55 percent backed up.
83 percent backed up.
99 percent backed up.
Processed 432 pages for database 'news', file 'news_dat' on
file 1.
100 percent backed up.
Processed 1 pages for database 'news', file 'news_log' on file
1.
BACKUP DATABASE successfully processed 433 pages in 0.326 seconds
(10.863 MB/sec).
---------------------------------------------------------
Press any key to exit . . .
C:\Program Files\Grass Valley\Aurora\DB Maintenance>
newsRestoreDb
WARNING: this will overwrite the current News database.
Template
newsRestoreDb <backup file name>
Example
C:\Program Files\Grass Valley\Aurora\DB Maintenance>
newsRestoreDb C:\backups\news.dat
4 October 2010
Aurora Edit Installation Guide
141
Database Maintenance