Hi. We had a little problem at the resort Sunday night. I got a call that my 24-7 reservation app was completely down.
After I arrived on the scene it became obvious that the RESERV.DBF file had been reduced from 280 MB to 25 MB. The CDX and FPT files were not affected.
We restored that table and an associated table from a Saturday night backup and got the system up but the front desk clerks had a good bit of work to redo the days check-ins and check-outs.
1) Has anyone ever seen this happen before? We are using local tables on a Windows 2003 server. We had some corruption issues years ago but I have never seen most of a file simply dissappear.
2) What experience do folks have with continuous backup possibilities (or hourly etc.)?
3) Going to SQL backend data storage would be an obvious improvment. It's on the list. :-)
Peter
Peter Robinson ** Rodes Design ** Virginia