August 26, 2014 at 7:53 pm
Hi all,
I am using SQL 2008
I 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
Any response really appreciate it
Cheers
August 26, 2014 at 9:31 pm
Backup plan you create depends on the application requirements... Basically, depends on your application RPO & RTO.
Regards,
SQLisAwe5oMe.
August 26, 2014 at 9:57 pm
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply