shohelr2003 (12/23/2012)
Imagine that I take one full backup at the beginning of the day and later on take four log backups at two hours interval and again take another full backup at the end of the day.How is this backup plan? .
Does it allow you to restore the DB and meet your RPO and RTO requirements? If so, it's fine. If not, it's inadequate.
There's no one-size-fits-all backup plan, it has to be tailored to meet the requirements for recovery for that DB.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability