beautypg.com

Scheduling automatic database backups – Grass Valley NewsShare v.5.5 User Manual

Page 106

background image

Appendix

Database Maintenance Utilities

104

Digital News Production

Scheduling Automatic Database Backups

>>> Caution: This utility should be used only by experts or as instructed by Grass

Valley personnel, due to required considerations of system load, system drive
space, network load, and necessary familiarity with the Windows at command
and Task Scheduler.

This command schedules a system event which will automatically back up the
News database every Monday at 3 am. The event in turn dispatches the
vbrAutoBack batch file, which affects these files in the \Program Files\Vibrint
3.0\DB Maintenance\ directory:

As each successive auto-backup occurs, the previous backup is shifted onto the
old images. After you have run newsInitAutoBack, use the at command or (on
Windows 2000) the Task Scheduler to reschedule the event to suit your facility.
Alternatively, without running newsInitAutoBack at all, you can directly
schedule an event to dispatch vbrAutoBack.

Before you use this utility, consider these cautions:

• The DNP, FSM and DSM systems are highly tuned for load. The backups

must occur only at times when the systems are quiescent. Disregarding this
caveat may cause erratic performance or system-wide failure.

• The backup files, particularly on an FSM or DSM, can become quite large

and thus deleteriously affect system performance. If your databases are
large, you should plan to move the backup files off the system as part of the
backup process.

• The DNP and Profile systems require very high Ethernet performance,

particularly for shared storage. If your backup strategy involves network
transfers of the backups, these systems must not be playing or recording any
clips.

newsAutoBack.dat

Most recent backup

newsAutoBack.old.dat

Previous backup

vNewsBackUpDb.log

Most recent backup log

vNewsBackUpDb.old.log

Previous backup log

This manual is related to the following products: