• Another consideration is what is your business and is a point in time recovery (PIT) worth the time after 4 or 24 hours?

    If a manager were to delete the days transactions at 4P and realized it at 5P then yes a PIT is probably the best way. But if the manager deleted the records from before 01/01/2014 when it was supposed to be a date of 01/01/2013 and he finds out two days later a PIT back to two days ago loses all work done for the past two days at a cost to the all the employees that use the DB for double-entry, while trying to maintain normal production.

    I have always looked at a PIT as essentially a 24 hour or less decision. The daily backups should be used to restore in parallel and then copy the data across.



    ----------------
    Jim P.

    A little bit of this and a little byte of that can cause bloatware.