[RBASE-L] - Re: Backup Practices.

[Doug Hamilton]

Javier, you caught one obvious mechanical problem - the flooding. Were there ever signs of electrical issues with the server?  I assume the server had its own dedicated, isolated power circuit.  However, depending on the size of the a/c unit, could the server be subject to some pretty hefty e-m fields when the fans turn on?  I'd opt to locate the server in an electrical "quiet zone" which would also minimize the risk being bumped during a/c maintenance. Just a thought. Doug Javier Valencia wrote:  A week ago, a client (public agency) had it server flooded and I mean that literally. The server room has a dedicated (elevated) AC unit and the server is/was located right under it. There is a tray under the AC unit to catch the condensation and a hose to direct the water from the tray to a drain, I had told them repeatedly in the past that the configuration was a recipe for disaster, and sure enough, last weekend the drain hose and drain clogged and the server got soaked; it will be at least another week before they have a new server installed and running. Luckily, I had downloaded the database a couple of days before so there will not be massive data loss, since their current procedure is to backup weekly to tape. I have a procedure in place to backup the database nightly and what I would like to do is set up a procedure (from within R:Base) that after the database is backed up, it sends a copy off-site; the 4 *.rx_ files are under 500 MB, so it is not too big. I think I would prefer not send it to one of the other County servers, as I am not sure their MIS department is competent enough not to screw it up. Has anyone implemented a procedure like this? Any suggestions? Advice? Caveats?   Javier,   Javier Valencia, PE 913-829-0888 Office 913-915-3137 Cell 913-649-2904 Fax Visit us at www.vtgonline.com