{"id":4974,"date":"2015-04-28T14:05:40","date_gmt":"2015-04-28T14:05:40","guid":{"rendered":"http:\/\/www.backupassist.com\/blog\/?p=4974"},"modified":"2019-11-07T05:58:58","modified_gmt":"2019-11-07T05:58:58","slug":"reducing-your-rpo-for-sql-servers","status":"publish","type":"post","link":"https:\/\/www.backupassist.com\/blog\/reducing-your-rpo-for-sql-servers","title":{"rendered":"Reducing your RPO for SQL Servers"},"content":{"rendered":"

\"reducing<\/a><\/p>\n

If your business deals with any significant amount of data, chances are an SQL Server is a vital part of your IT environment.  There’s no doubt that you’re backing this server up regularly, because in a contemporary business environment you can’t afford to risk losing those databases.  But the real question is, have you thought about recovery?<\/p>\n

RPO (Recovery Point Objective) refers to how much data your company can afford to lose during a recovery.  It’s what dictates the kinds of backups you perform and how regularly.  The key point to keep in mind is that, as with all elements of your backup strategy, your RPO for SQL Servers needs to be both adequate and realistic.  So how do you know if yours is?<\/p>\n

<\/p>\n

Well, let’s find out.<\/p>\n

Determining RPO for SQL Servers<\/h2>\n

\"RPO<\/p>\n

Before we start, it’s worth making sure everyone’s clear on exactly what RPO means and how you should go about calculating it.  If you’re not 100% on either of those things, take a couple of minutes to read this article first<\/a>.  Don’t worry, we’ll be waiting right here for you.<\/p>\n

And we’re back. Let’s get into why knowing your RPO for SQL Servers is important, and how you should go about determining it.<\/p>\n

The thing about SQL Servers that often differentiates them from some other server applications is the frequency with which their data is updated.  Because databases are in a state of near-continuous change  you may need to protect this data more regularly.  Whereas a daily backup (giving you an RPO of 24 hours) might be fine for a file server, an SQL Server can contain a great deal of critical data that has been updated during this time.<\/p>\n

That means a general rule-of-thumb for determining your RPO for an SQL Server is the lower the better.<\/p>\n

In order to determine the ideal RPO for your company’s SQL Servers, you need to first identify how much of your critical database data changes and how much new data is added – i.e. data that would cause harmful impact (be it financial, regulatory or otherwise) if your company lost it.<\/p>\n

Reducing your RPO for SQL Servers with BackupAssist<\/h2>\n

\"RPO<\/p>\n

So you’ve identified your RPO, and it’s lower than what you’re currently achieving.  Well, the good news is you can use BackupAssist’s SQL Protection Add-on<\/a> to remedy this.<\/p>\n

While the base license of BackupAssist can protect full-server backups and restores, this can limit your RPO to however frequently your backup window makes it practical to perform one – generally no more than twice per day.  This is absolutely fine if you’ve determined that your databases aren’t being populated with mission critical data within that period.  And for many users, this will be the case and the Base License of BackupAssist will suit their needs perfectly.<\/p>\n

But what if you’ve determined you’ll need to protect data hourly? What if there’s vital data being updated every 10 minutes?<\/p>\n

One of the main ways the SQL Protection Add-on improves your RPO for SQL Servers is by performing near-continuous transaction level backups.  What this essentially means, is that any changes to the SQL Server databases (transactions) will be logged in regular intervals (as frequently as every 5 minutes, giving you the ability to restore the database to a point-in-time.<\/p>\n

That means you can still run your scheduled backup once per day, but within that backup will be the ability to restore to a point-in-time within a 5 minute period any time since the previous day’s backup.  Therefore, instead of an RPO of 24 hours, you now have an RPO that can be as little as 5 minutes, without changing the frequency with which you perform your SQL Server backup.<\/p>\n

Want some more in-depth information on the BackupAssist SQL Protection Add-on? Check out this detailed whitepaper<\/a>.<\/p>\n

What’s the RPO for your SQL Servers?
\nWe’d love to hear! Leave a comment, tweet @BackupAssist<\/a> or post to Facebook<\/a>.
\nShare this article, and let’s better protect databases everywhere.<\/p>\n","protected":false},"excerpt":{"rendered":"

If your business deals with any significant amount of data, chances are an SQL Server is a vital part of your IT environment.  There’s no doubt that you’re backing this server up regularly, because in a contemporary business environment you can’t afford to risk losing those databases.  But the real question is, have you thought about … Read more Reducing your RPO for SQL Servers<\/span><\/a><\/p>\n","protected":false},"author":14,"featured_media":4977,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22,23,760],"tags":[],"class_list":["post-4974","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-interest","category-news","category-legacy"],"yoast_head":"\nReducing your RPO for SQL Servers | BackupAssist<\/title>\n<meta name=\"description\" content=\"SQL Server databases are often updated more often than many other applications. That's why a low RPO is important. Here's how to reduce RPO for SQL Servers.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.backupassist.com\/blog\/reducing-your-rpo-for-sql-servers\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Reducing your RPO for SQL Servers\" \/>\n<meta property=\"og:description\" content=\"SQL Server databases are often updated more often than many other applications. That's why a low RPO is important. Here's how to reduce RPO for SQL Servers using BackupAssist.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.backupassist.com\/blog\/reducing-your-rpo-for-sql-servers\" \/>\n<meta property=\"og:site_name\" content=\"Cyber Resilience Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-04-28T14:05:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-11-07T05:58:58+00:00\" \/>\n<meta name=\"author\" content=\"Luke Parsons\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Reducing your RPO for SQL Servers\" \/>\n<meta name=\"twitter:description\" content=\"SQL Server databases are often updated more often than many other applications. That's why a low RPO is important. Here's how to reduce RPO for SQL Servers using BackupAssist.\" \/>\n<meta name=\"twitter:image\" content=\"http:\/\/www.backupassist.com\/blog\/wp-content\/uploads\/2015\/04\/software-557616_640.jpg\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Luke Parsons\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.backupassist.com\/blog\/reducing-your-rpo-for-sql-servers#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.backupassist.com\/blog\/reducing-your-rpo-for-sql-servers\"},\"author\":{\"name\":\"Luke Parsons\",\"@id\":\"https:\/\/www.backupassist.com\/blog\/#\/schema\/person\/11c97915d32eff768b2f8739e7d37297\"},\"headline\":\"Reducing your RPO for SQL Servers\",\"datePublished\":\"2015-04-28T14:05:40+00:00\",\"dateModified\":\"2019-11-07T05:58:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.backupassist.com\/blog\/reducing-your-rpo-for-sql-servers\"},\"wordCount\":687,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.backupassist.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.backupassist.com\/blog\/reducing-your-rpo-for-sql-servers#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.backupassist.com\/app\/uploads\/sites\/3\/2015\/04\/RPO-for-SQL.jpg\",\"articleSection\":[\"Interest\",\"News\",\"Z-Legacy\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.backupassist.com\/blog\/reducing-your-rpo-for-sql-servers#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.backupassist.com\/blog\/reducing-your-rpo-for-sql-servers\",\"url\":\"https:\/\/www.backupassist.com\/blog\/reducing-your-rpo-for-sql-servers\",\"name\":\"Reducing your RPO for SQL Servers | BackupAssist\",\"isPartOf\":{\"@id\":\"https:\/\/www.backupassist.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.backupassist.com\/blog\/reducing-your-rpo-for-sql-servers#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.backupassist.com\/blog\/reducing-your-rpo-for-sql-servers#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.backupassist.com\/app\/uploads\/sites\/3\/2015\/04\/RPO-for-SQL.jpg\",\"datePublished\":\"2015-04-28T14:05:40+00:00\",\"dateModified\":\"2019-11-07T05:58:58+00:00\",\"description\":\"SQL Server databases are often updated more often than many other applications. That's why a low RPO is important. Here's how to reduce RPO for SQL Servers.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.backupassist.com\/blog\/reducing-your-rpo-for-sql-servers#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.backupassist.com\/blog\/reducing-your-rpo-for-sql-servers\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.backupassist.com\/blog\/reducing-your-rpo-for-sql-servers#primaryimage\",\"url\":\"https:\/\/www.backupassist.com\/app\/uploads\/sites\/3\/2015\/04\/RPO-for-SQL.jpg\",\"contentUrl\":\"https:\/\/www.backupassist.com\/app\/uploads\/sites\/3\/2015\/04\/RPO-for-SQL.jpg\",\"width\":640,\"height\":250,\"caption\":\"reducing RPO for SQL Server\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.backupassist.com\/blog\/reducing-your-rpo-for-sql-servers#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.backupassist.com\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Reducing your RPO for SQL Servers\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.backupassist.com\/blog\/#website\",\"url\":\"https:\/\/www.backupassist.com\/blog\/\",\"name\":\"Cyber Resilience Blog\",\"description\":\"Protect Your Cloud Data with BackupAssist\",\"publisher\":{\"@id\":\"https:\/\/www.backupassist.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.backupassist.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.backupassist.com\/blog\/#organization\",\"name\":\"Cyber Resilience Blog\",\"url\":\"https:\/\/www.backupassist.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.backupassist.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.backupassist.com\/app\/uploads\/sites\/3\/2019\/09\/BA-Logo-Full-Logo.svg\",\"contentUrl\":\"https:\/\/www.backupassist.com\/app\/uploads\/sites\/3\/2019\/09\/BA-Logo-Full-Logo.svg\",\"caption\":\"Cyber Resilience Blog\"},\"image\":{\"@id\":\"https:\/\/www.backupassist.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.backupassist.com\/blog\/#\/schema\/person\/11c97915d32eff768b2f8739e7d37297\",\"name\":\"Luke Parsons\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.backupassist.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2c6eec44e45e95d0501fd5b72357cc1d12b2b1208d93f8a4e0766c387aee0e2f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2c6eec44e45e95d0501fd5b72357cc1d12b2b1208d93f8a4e0766c387aee0e2f?s=96&d=mm&r=g\",\"caption\":\"Luke Parsons\"},\"url\":\"https:\/\/www.backupassist.com\/blog\/author\/luke-parsons\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Reducing your RPO for SQL Servers | BackupAssist","description":"SQL Server databases are often updated more often than many other applications. That's why a low RPO is important. Here's how to reduce RPO for SQL Servers.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.backupassist.com\/blog\/reducing-your-rpo-for-sql-servers","og_locale":"en_US","og_type":"article","og_title":"Reducing your RPO for SQL Servers","og_description":"SQL Server databases are often updated more often than many other applications. That's why a low RPO is important. Here's how to reduce RPO for SQL Servers using BackupAssist.","og_url":"https:\/\/www.backupassist.com\/blog\/reducing-your-rpo-for-sql-servers","og_site_name":"Cyber Resilience Blog","article_published_time":"2015-04-28T14:05:40+00:00","article_modified_time":"2019-11-07T05:58:58+00:00","author":"Luke Parsons","twitter_card":"summary_large_image","twitter_title":"Reducing your RPO for SQL Servers","twitter_description":"SQL Server databases are often updated more often than many other applications. That's why a low RPO is important. Here's how to reduce RPO for SQL Servers using BackupAssist.","twitter_image":"http:\/\/www.backupassist.com\/blog\/wp-content\/uploads\/2015\/04\/software-557616_640.jpg","twitter_misc":{"Written by":"Luke Parsons","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.backupassist.com\/blog\/reducing-your-rpo-for-sql-servers#article","isPartOf":{"@id":"https:\/\/www.backupassist.com\/blog\/reducing-your-rpo-for-sql-servers"},"author":{"name":"Luke Parsons","@id":"https:\/\/www.backupassist.com\/blog\/#\/schema\/person\/11c97915d32eff768b2f8739e7d37297"},"headline":"Reducing your RPO for SQL Servers","datePublished":"2015-04-28T14:05:40+00:00","dateModified":"2019-11-07T05:58:58+00:00","mainEntityOfPage":{"@id":"https:\/\/www.backupassist.com\/blog\/reducing-your-rpo-for-sql-servers"},"wordCount":687,"commentCount":0,"publisher":{"@id":"https:\/\/www.backupassist.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.backupassist.com\/blog\/reducing-your-rpo-for-sql-servers#primaryimage"},"thumbnailUrl":"https:\/\/www.backupassist.com\/app\/uploads\/sites\/3\/2015\/04\/RPO-for-SQL.jpg","articleSection":["Interest","News","Z-Legacy"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.backupassist.com\/blog\/reducing-your-rpo-for-sql-servers#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.backupassist.com\/blog\/reducing-your-rpo-for-sql-servers","url":"https:\/\/www.backupassist.com\/blog\/reducing-your-rpo-for-sql-servers","name":"Reducing your RPO for SQL Servers | BackupAssist","isPartOf":{"@id":"https:\/\/www.backupassist.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.backupassist.com\/blog\/reducing-your-rpo-for-sql-servers#primaryimage"},"image":{"@id":"https:\/\/www.backupassist.com\/blog\/reducing-your-rpo-for-sql-servers#primaryimage"},"thumbnailUrl":"https:\/\/www.backupassist.com\/app\/uploads\/sites\/3\/2015\/04\/RPO-for-SQL.jpg","datePublished":"2015-04-28T14:05:40+00:00","dateModified":"2019-11-07T05:58:58+00:00","description":"SQL Server databases are often updated more often than many other applications. That's why a low RPO is important. Here's how to reduce RPO for SQL Servers.","breadcrumb":{"@id":"https:\/\/www.backupassist.com\/blog\/reducing-your-rpo-for-sql-servers#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.backupassist.com\/blog\/reducing-your-rpo-for-sql-servers"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.backupassist.com\/blog\/reducing-your-rpo-for-sql-servers#primaryimage","url":"https:\/\/www.backupassist.com\/app\/uploads\/sites\/3\/2015\/04\/RPO-for-SQL.jpg","contentUrl":"https:\/\/www.backupassist.com\/app\/uploads\/sites\/3\/2015\/04\/RPO-for-SQL.jpg","width":640,"height":250,"caption":"reducing RPO for SQL Server"},{"@type":"BreadcrumbList","@id":"https:\/\/www.backupassist.com\/blog\/reducing-your-rpo-for-sql-servers#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.backupassist.com\/blog"},{"@type":"ListItem","position":2,"name":"Reducing your RPO for SQL Servers"}]},{"@type":"WebSite","@id":"https:\/\/www.backupassist.com\/blog\/#website","url":"https:\/\/www.backupassist.com\/blog\/","name":"Cyber Resilience Blog","description":"Protect Your Cloud Data with BackupAssist","publisher":{"@id":"https:\/\/www.backupassist.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.backupassist.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.backupassist.com\/blog\/#organization","name":"Cyber Resilience Blog","url":"https:\/\/www.backupassist.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.backupassist.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.backupassist.com\/app\/uploads\/sites\/3\/2019\/09\/BA-Logo-Full-Logo.svg","contentUrl":"https:\/\/www.backupassist.com\/app\/uploads\/sites\/3\/2019\/09\/BA-Logo-Full-Logo.svg","caption":"Cyber Resilience Blog"},"image":{"@id":"https:\/\/www.backupassist.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.backupassist.com\/blog\/#\/schema\/person\/11c97915d32eff768b2f8739e7d37297","name":"Luke Parsons","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.backupassist.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2c6eec44e45e95d0501fd5b72357cc1d12b2b1208d93f8a4e0766c387aee0e2f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2c6eec44e45e95d0501fd5b72357cc1d12b2b1208d93f8a4e0766c387aee0e2f?s=96&d=mm&r=g","caption":"Luke Parsons"},"url":"https:\/\/www.backupassist.com\/blog\/author\/luke-parsons"}]}},"_links":{"self":[{"href":"https:\/\/www.backupassist.com\/blog\/wp-json\/wp\/v2\/posts\/4974","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.backupassist.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.backupassist.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.backupassist.com\/blog\/wp-json\/wp\/v2\/users\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/www.backupassist.com\/blog\/wp-json\/wp\/v2\/comments?post=4974"}],"version-history":[{"count":2,"href":"https:\/\/www.backupassist.com\/blog\/wp-json\/wp\/v2\/posts\/4974\/revisions"}],"predecessor-version":[{"id":13293,"href":"https:\/\/www.backupassist.com\/blog\/wp-json\/wp\/v2\/posts\/4974\/revisions\/13293"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.backupassist.com\/blog\/wp-json\/wp\/v2\/media\/4977"}],"wp:attachment":[{"href":"https:\/\/www.backupassist.com\/blog\/wp-json\/wp\/v2\/media?parent=4974"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.backupassist.com\/blog\/wp-json\/wp\/v2\/categories?post=4974"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.backupassist.com\/blog\/wp-json\/wp\/v2\/tags?post=4974"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}