Quote:
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.