• WhiteLotus (8/26/2014)[/bI wonder can I perform full backup every week but transactional log every day ( every 3 hours ) because i am going to perform Rebuild /Reorganize process everyday

    Your index maintenance should have no consideration on how your recovery plan is designed.

    Think about the process to recover a database if you were to only take a full backup on Sunday morning and it failed at 5PM on Friday evening. Taking that log backups start at 00:00, every 3 hours means you could only restore back to the last log backup taken at 3:00 PM that day. If you are able to get a tail log backup, depending on what caused the database to crash or require a restore then you might get up to 5PM that evening. You are hoping that all the log backups between that time and Sunday are good. If you are not able to get a tail log backup, then you should expect the 2 hour loss of data is sufficient for your business, you will have to restore 45 log backups.

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton