Always test, and be aware of the possible problems

  • Whilst having "full recovery" allows a "point in time" restore, it also means that you *must* do regular transaction log backups. Not just because this gives you the control over which point in time to restore to, but also because this is how the transaction log is checkpointed. Failure to do this can easily lead to the transaction log growing out of control.

    Implementing this does imply a greater level of care in monitoring that the backups are working and running as and when expected.

    And the most important thing with ay backup... test it before you need it. You should always go through a restore to makes sure that it works as you expected. The last thing you ever want to do is to have a failure or data loss and find out at that time that the backups are bad.

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply