On Fri, 30 Apr 2010, Jeff Kaminsky wrote:
At the time we did this the only thing that looked off was the 1800 invoices, they were actually an easy fix, a little time consuming, but we thought that was all the problems that were created. It was two weeks later when I tried doing reconciliations that things were wonky, and it wasnt until even later that I for sure knew my cogs were off. So thats were we stand, a month into the script.
Ouch!
Thoughts?
Nothing useful, I'm sorry to write. While it would not help right now, something to consider for the future is how you do your backups. After about 25 years of tape backups (daily incremental and weekly full), I recently needed to buy new tapes (at $72 each) and had a limited capacity that I had really outgrown. Rather than buying a new tape drive ($$$) and set of tapes ($$), I bought a 300G SATA2 hard drive and an external USB2 case for $81. I'm now using dirvish <http://www.dirvish.org/> for daily backups. Based on rsync, with dirvish you set up an initial backup of each partition in its own 'vault' (each server can be set up as a separate 'bank'), then the daily backups are only of files that changed, and the specific changes to those files. You can set expiration dates at your convenience; e.g., daily files for a month and Sunday files for a year. The big advantage is that you can restore the system (or any files) to any previous date. In your case, a couple of weeks ago. While dirvish's documentation leaves a lot to be desired, the mail list help is outstanding. Once you have the backup device configured properly and your scripts doing what you want, it's automatic. There's even a script that can turn on the external drive before the nightly backup and turn it off afterwards; I do this manually and only forget now and then.) With the local Fry's discount chain selling 2T external drives for $130 you can back up a lot of data each day and save it for a long time just in case you need it. Rich _______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
