> > They should be able to restore yesterday's backup, archive some of > > the database to reduce it's size, and then apply changes from > > yesterday using images of changes stored in an audit trail. > > The problem is this *was* the audit trail. There's a paper > audit trail but it would be hard to recreate things like > credit card payments.
I use the term 'audit trail' to refer to a secondary table (optimally on a different drive/machine) that contains images of transactions applied to the table being audited. If the audit trail is corrupted, it's loss is not consequential so long as the main table is not corrupted at the same time. I'm sure you appreciate I'm not trying to be harsh. The reality of the situation is the harsh part. Are you using buffering? I find it helps a whole lot. Only corruption I've seen in a long time is CDX's, and that's very rare, but has happened. > To make matters worse this client had a problem a few weeks > ago where 2 days worth of transactions 'disappeared'. We > can't be sure if it was the (rather cute, young Swedish woman > :-) first line support who fucked up or some kind of network > problem. I suspect a flaky network after speaking to the > local network guy today. > > > The code that connects a table with the potential to reach the size > > limit should test table size and when it exceeds say 90% of the max > > put up progressively urgent warning messages saying it's time to > > archive some data. > > It was a corruption rather than a table growing too big. The > real data size was 115Mb. I believe the use of buffering + audit trails will ward off these evil spirits Bill > -- > Paul _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
