July 9, 2015 at 10:42 am
WHAT IS THE MINIMUM POSSIBLE DATA LOSS?
1 HOUR?
1 MINUTE?
10 SECONDS??
July 9, 2015 at 10:45 am
sindura.pulimamidi1 (7/9/2015)
WHAT IS THE MINIMUM POSSIBLE DATA LOSS?1 HOUR?
1 MINUTE?
10 SECONDS??
That depends on your businesses RPO/RTO/SLA agreements. It isn't something we can just say this is the minimum data loss you can afford.
July 9, 2015 at 11:03 am
Further on to Lynn's answer, and coining an oxymoron, the more you spend the less you loose, simplified ((Transaction Volume/Time) x (Cost of backup)) * (1 / (Allowed Data Loss)). Of course there are many factors which affect this but if the requirements are less than few minutes of data loss, the cost starts to rise very very fast.
😎
July 9, 2015 at 1:36 pm
sindura.pulimamidi1 (7/9/2015)
WHAT IS THE MINIMUM POSSIBLE DATA LOSS?1 HOUR?
1 MINUTE?
10 SECONDS??
Depends on the backups you have and the type of disaster. Anything from all of it to none.
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
July 10, 2015 at 2:34 am
Maybe you mean how frequently can you run log backups?
You can run them as frequently as they complete, but no faster. Considering the management overhead and the work involved in recovery, I don't think I would run them much more often than every 5 minutes. Even that could mean a lot of files that you have to manage.
But as others have said, this is a technical question. How much data your company can afford to lose is a business question.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply