Timeline for SQL Server Backup Proposal
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 22, 2014 at 14:52 | comment | added | Shanky | As per RTO it seems fine. But nothing is full proof unless you test it like real world scenario. Now you asked good question 'How do I assess how recovery will fit within the RTO 1hr limit' answer would be do a DR testing or simulate a database or server failure and see if you can, withing 1 hour, recovery database with maximum of 15mins data loss. | |
| Jul 22, 2014 at 14:49 | comment | added | K09 | RPO is 15mins; RTO is 1hr. So one Full Backup each day, Differential Backup every 30mins, Log Backup every 15mins(RPO). Does this sound correct? How do I assess how recovery will fit within the RTO 1hr limit? | |
| Jul 22, 2014 at 12:30 | history | answered | Shanky | CC BY-SA 3.0 |