Originally posted by pando
the problem withj export import is not that you can lose 24 hour or 48 hours data whateever

the problem is you need to recreate a new database, import is slow as hell, can your company afford 5 ~6 hours downtime (for a small database)? our development database ranges from 10gb to 100gb, if I had to restore the 50gb+ ones how long it would take? probably one whole day, with backup takes one hour or less or more but not a whole day that's for sure

if you can afford that downtime so then go ahead and do your export/import
But again in a large company this is all agreed to.

Most of the time you are recovering one table.
Never since I have been here have we had complete failure on a system. Not that that is any kind of reason for using imp/exp.
Usually with the larger DB's the recovery time is taken into account before a B&R methodology is decided upon.

MH