This page is to assist us to convert the stock room's software backup plans into a work flow. And have that work flow tested, updated as necessary, and properly documented. Documentation started below. |
From "CU Chem Stockroom - Project Outline v2012-11-28v2", pg 2:
Scope of Work => Phase 2: Planning & Design => Task 2.3 – Technical Preparation
Frequency of backups
Confirmation of bakups
Verification of process
Notification
Manual validity checks
With the data file, a restore gets back the core business data.
Export QB database (DB) to a file.
Copy that file to A&S file server.
With a VM back up, in addition to a data file snapshot (see above), also gets a copy of the structure. Thus consider doing at least whenever there is a change to the structure, such as changes to the QB structure or OS configuration. (And right before major changes to ensure current roll-back image is available!)
Do it manually.
Requires shutting off QB, and takes a while (~1/2 day).
Q: Bother backing up MySQL database (DB)?
A: Yes! Transaction logs would be valuable in debugging processing problems. Also, logs are depended on when the QB DB is not running (which will be very often- basically when it's not being used).
Export MySQL DB to a file.
Copy that file to A&S file server.
With a VM back up, in addition to a data file snapshot (see above), also gets a copy of the structure. Thus consider doing at least whenever there is a change to the structure, such as changes to the web (Apache) structure, DB structure (MySQL), or OS configuration. (And right before major changes to ensure current roll-back image is available!)
Do it manually.
Requires shutting off web services so kiosk will not be operational. Although smaller than the QB VM, still will take a while (~1/2 day).
Require structure/ rebuild docs for QB (Brightworks) and Apache/MySQL/PHP?/etc (Gorges).