Graph to show downtime / data loss?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Database Design » Disaster Recovery » Graph to show downtime / data loss?

Graph to show downtime / data loss?

Rate Topic

Display Mode

Topic Options

Author

Message

derek.colley

Posted Tuesday, October 16, 2012 7:24 AM

SSC-Addicted

Group: General Forum Members
Last Login: Today @ 3:41 AM
Points: 496, Visits: 587

Not long ago I came across a graph plotting acceptable system downtime and acceptable data loss in an easy-to-understand format in the context of disaster recovery. The idea of the presentation was that acceptable maximum downtime limits and maximum data loss limits should be agreed with the business/customer in the SLA, and these thresholds guide the DBA's disaster recovery strategy.

I've seen this graph/concept before in a couple of places, and it has a specific name, too, but it's eluding me. Does anyone know what I'm talking about and can post a link or more details (or did I just dream the whole thing up?)

Thanks!

---

Note to developers:
CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
So why complicate your code AND MAKE MY JOB HARDER??! Crazy

Want to get the best help? Click here http://www.sqlservercentral.com/articles/Best+Practices/61537/ (Jeff Moden)
My blog: http://uksqldba.blogspot.com
Visit http://www.DerekColley.co.uk to find out more about me.

Post #1373240

Grant Fritchey

Posted Wednesday, October 17, 2012 8:28 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 9:49 AM
Points: 13,436, Visits: 25,281

Do you mean the Recovery Time Objective and Recovery Point Objective? RTO being how long it takes to get back online and RPO being how much data you can afford to lose.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #1373837

derek.colley

Posted Thursday, October 18, 2012 3:18 AM

SSC-Addicted

Group: General Forum Members
Last Login: Today @ 3:41 AM
Points: 496, Visits: 587

Grant, that's exactly what I mean. Thanks very much for your reply!

---

Note to developers:
CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
So why complicate your code AND MAKE MY JOB HARDER??! Crazy

Post #1374209

« Prev Topic | Next Topic »

Permissions