Post reply

Bulk-logged Recovery

  • December 19, 2005 at 9:34 am

    #167395

    Hi,

    I have a question regarding bulk-logged recovery mode. If you switch from full recovery to bulk-logged recovery, and perform your bulk operation while updates are coming in, then shortly after you complete the bulk operation, you experience system failure. Can you recovery the updates that took place after you switched to bulk-logged recovery mode if you haven't take any database backups after you switched. What is the chosen strategy when you switch to bulk-logged recovery mode to avoid data loss in case of system or media failure. Please clarify.

     

    Thanks,

    Karim

  • December 19, 2005 at 9:57 am

    #610362

    When you switch recovery modes out of simple modes, then you do need a fullbackup. You can switch between bulk and full without this. If it fails after your load, then you can still recover to the end of the load.

  • December 20, 2005 at 10:33 am

    #610656

    The 'paranoid' DBA in me now comes to light ... To be on the safe side I always perform a full backup every time I switch recovery modes ... Backup is fast, disk space is cheap ... besides one never knows when one will encounter a "new" undocumented feature (bug) ...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 3 posts - 1 through 2 (of 2 total)

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