<!doctypehtml><html lang=en-US><meta charset=utf-8><meta content="Find out what the most important responsibility of a database administrator is and understand their role in the business."name=description><meta content="SQL Server,SQL Server Database Administrator, SQL Server DBA, most important responsibility of DBA, primary dba responsibility, data loss, data loss event, SQL Server Essentials"name=keywords><meta content=width=device-width,initial-scale=1 name=viewport><title>
   The Database Administrator’s Primary Responsibility – John Sansom
  </title><meta content=max-image-preview:large name=robots><link href=//www.google.com rel=dns-prefetch><link href=//fonts.googleapis.com rel=dns-prefetch><link href=//s.w.org rel=dns-prefetch><link title="John Sansom » Feed"href=https://feeds.feedburner.com/JohnSansom-SqlServerDba rel=alternate type=application/rss+xml><link title="John Sansom » Comments Feed"href=https://www.johnsansom.com/comments/feed/ rel=alternate type=application/rss+xml><link title="John Sansom » The Database Administrator’s Primary Responsibility Comments Feed"href=https://www.johnsansom.com/the-database-administrators-primary-responsibility/feed/ rel=alternate type=application/rss+xml><link href=https://www.johnsansom.com/the-database-administrators-primary-responsibility/ rel=canonical><script>window._wpemojiSettings = {"baseUrl":"https:\/\/s.w.org\/images\/core\/emoji\/13.1.0\/72x72\/","ext":".png","svgUrl":"https:\/\/s.w.org\/images\/core\/emoji\/13.1.0\/svg\/","svgExt":".svg","source":{"concatemoji":"https:\/\/www.johnsansom.com\/wp-includes\/js\/wp-emoji-release.min.js?ver=5.8.1"}};
			!function(e,a,t){var n,r,o,i=a.createElement("canvas"),p=i.getContext&&i.getContext("2d");function s(e,t){var a=String.fromCharCode;p.clearRect(0,0,i.width,i.height),p.fillText(a.apply(this,e),0,0);e=i.toDataURL();return p.clearRect(0,0,i.width,i.height),p.fillText(a.apply(this,t),0,0),e===i.toDataURL()}function c(e){var t=a.createElement("script");t.src=e,t.defer=t.type="text/javascript",a.getElementsByTagName("head")[0].appendChild(t)}for(o=Array("flag","emoji"),t.supports={everything:!0,everythingExceptFlag:!0},r=0;r<o.length;r++)t.supports[o[r]]=function(e){if(!p||!p.fillText)return!1;switch(p.textBaseline="top",p.font="600 32px Arial",e){case"flag":return s([127987,65039,8205,9895,65039],[127987,65039,8203,9895,65039])?!1:!s([55356,56826,55356,56819],[55356,56826,8203,55356,56819])&&!s([55356,57332,56128,56423,56128,56418,56128,56421,56128,56430,56128,56423,56128,56447],[55356,57332,8203,56128,56423,8203,56128,56418,8203,56128,56421,8203,56128,56430,8203,56128,56423,8203,56128,56447]);case"emoji":return!s([10084,65039,8205,55357,56613],[10084,65039,8203,55357,56613])}return!1}(o[r]),t.supports.everything=t.supports.everything&&t.supports[o[r]],"flag"!==o[r]&&(t.supports.everythingExceptFlag=t.supports.everythingExceptFlag&&t.supports[o[r]]);t.supports.everythingExceptFlag=t.supports.everythingExceptFlag&&!t.supports.flag,t.DOMReady=!1,t.readyCallback=function(){t.DOMReady=!0},t.supports.everything||(n=function(){t.readyCallback()},a.addEventListener?(a.addEventListener("DOMContentLoaded",n,!1),e.addEventListener("load",n,!1)):(e.attachEvent("onload",n),a.attachEvent("onreadystatechange",function(){"complete"===a.readyState&&t.readyCallback()})),(n=t.source||{}).concatemoji?c(n.concatemoji):n.wpemoji&&n.twemoji&&(c(n.twemoji),c(n.wpemoji)))}(window,document,window._wpemojiSettings);</script><style>img.wp-smiley,
img.emoji {
	display: inline !important;
	border: none !important;
	box-shadow: none !important;
	height: 1em !important;
	width: 1em !important;
	margin: 0 .07em !important;
	vertical-align: -0.1em !important;
	background: none !important;
	padding: 0 !important;
}</style><link href=https://www.johnsansom.com/wp-content/themes/metro-pro/style.css?ver=2.0.1 id=metro-pro-theme-css media=all rel=stylesheet><link href=https://www.johnsansom.com/wp-includes/css/dist/block-library/style.min.css?ver=5.8.1 id=wp-block-library-css media=all rel=stylesheet><link href=https://www.johnsansom.com/wp-content/plugins/contact-form-7/includes/css/styles.css?ver=5.4.2 id=contact-form-7-css media=all rel=stylesheet><link href=https://www.johnsansom.com/wp-content/plugins/wordpress-popular-posts/assets/css/wpp.css?ver=5.4.2 id=wordpress-popular-posts-css-css media=all rel=stylesheet><link href=//fonts.googleapis.com/css?family=Oswald%3A400&ver=2.0.1 id=google-font-css media=all rel=stylesheet><script id=wpp-json type=application/json>
   {"sampling_active":0,"sampling_rate":100,"ajax_url":"https:\/\/www.johnsansom.com\/wp-json\/wordpress-popular-posts\/v1\/popular-posts","api_url":"https:\/\/www.johnsansom.com\/wp-json\/wordpress-popular-posts","ID":987,"token":"923688960f","lang":0,"debug":0}
  </script><script id=wpp-js-js src=https://www.johnsansom.com/wp-content/plugins/wordpress-popular-posts/assets/js/wpp.min.js?ver=5.4.2></script><script id=jquery-core-js src=https://www.johnsansom.com/wp-includes/js/jquery/jquery.min.js?ver=3.6.0></script><script id=jquery-migrate-js src=https://www.johnsansom.com/wp-includes/js/jquery/jquery-migrate.min.js?ver=3.3.2></script><script id=metro-pro-backstretch-js src=https://www.johnsansom.com/wp-content/themes/metro-pro/js/backstretch.js?ver=1.0.0></script><script id=metro-pro-backstretch-set-js-extra>/* <![CDATA[ */
var BackStretchImg = {"src":"https:\/\/www.johnsansom.com\/wp-content\/uploads\/2014\/07\/bg_sp2.jpg"};
/* ]]> */</script><script id=metro-pro-backstretch-set-js src=https://www.johnsansom.com/wp-content/themes/metro-pro/js/backstretch-set.js?ver=1.0.0></script><link href=https://www.johnsansom.com/wp-json/ rel=https://api.w.org/><link href=https://www.johnsansom.com/wp-json/wp/v2/posts/987 rel=alternate type=application/json><link href=https://www.johnsansom.com/xmlrpc.php?rsd rel=EditURI title=RSD type=application/rsd+xml><link href=https://www.johnsansom.com/wp-json/oembed/1.0/embed?url=https%3A%2F%2Fwww.johnsansom.com%2Fthe-database-administrators-primary-responsibility%2F rel=alternate type=application/json+oembed><link href=https://www.johnsansom.com/wp-json/oembed/1.0/embed?url=https%3A%2F%2Fwww.johnsansom.com%2Fthe-database-administrators-primary-responsibility%2F&format=xml rel=alternate type=text/xml+oembed><link href=https://www.johnsansom.com/the-database-administrators-primary-responsibility/ rel=canonical><style>@-webkit-keyframes bgslide {
                from {
                    background-position-x: 0;
                }
                to {
                    background-position-x: -200%;
                }
            }

            @keyframes bgslide {
                    from {
                        background-position-x: 0;
                    }
                    to {
                        background-position-x: -200%;
                    }
            }

            .wpp-widget-placeholder {
                margin: 0 auto;
                width: 60px;
                height: 3px;
                background: #dd3737;
                background: -webkit-gradient(linear, left top, right top, from(#dd3737), color-stop(10%, #571313), to(#dd3737));
                background: linear-gradient(90deg, #dd3737 0%, #571313 10%, #dd3737 100%);
                background-size: 200% auto;
                border-radius: 3px;
                -webkit-animation: bgslide 1s infinite linear;
                animation: bgslide 1s infinite linear;
            }</style><link href=https://www.johnsansom.com/wp-content/themes/metro-pro/images/favicon.ico rel=icon><link href=https://www.johnsansom.com/xmlrpc.php rel=pingback><script>(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
  (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
  m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
  })(window,document,'script','//www.google-analytics.com/analytics.js','ga');

  ga('create', 'UA-6996459-1', {'siteSpeedSampleRate': 100});
  ga('require', 'displayfeatures');
  ga('send', 'pageview');</script><style>.site-title a { background: url(https://www.johnsansom.com/wp-content/uploads/2014/04/logo.png) no-repeat !important; }</style><body class="post-template-default single single-post postid-987 single-format-standard custom-background custom-header header-image content-sidebar genesis-breadcrumbs-hidden genesis-footer-widgets-hidden"itemscope itemtype=https://schema.org/WebPage><nav aria-label=Secondary class=nav-secondary itemscope itemtype=https://schema.org/SiteNavigationElement><div class=wrap><ul class="menu genesis-nav-menu menu-secondary"id=menu-top-menu><li class="menu-item menu-item-type-custom menu-item-object-custom menu-item-home menu-item-14749"id=menu-item-14749><a title="Blog Home"href=https://www.johnsansom.com itemprop=url> <span itemprop=name> Home </span> </a><li class="menu-item menu-item-type-post_type menu-item-object-page menu-item-10075"id=menu-item-10075><a href=https://www.johnsansom.com/contact-me/ itemprop=url> <span itemprop=name> Contact </span> </a></ul></div></nav><div class=site-container><header class=site-header itemscope itemtype=https://schema.org/WPHeader><div class=wrap><div class=title-area><p class=site-title itemprop=headline><a href=https://www.johnsansom.com/> John Sansom </a><p class=site-description itemprop=description>SQL Server DBA Blog</div><div class="widget-area header-widget-area"><section class="widget social_stickers_widget"id=social_stickers_widget-7><div class=widget-wrap><div align=right><p><a onclick="_gaq.push(['_trackEvent', 'SocialButton', 'Click', 'Twitter']);"href=https://twitter.com/SqlBrit style=text-decoration:none; target=_blank title=Twitter> <img height=64 src=https://www.johnsansom.com/wp-content/plugins/social-stickers/themes/default/twitter.png width=64> </a> <a onclick="_gaq.push(['_trackEvent', 'SocialButton', 'Click', 'Facebook']);"href=https://facebook.com/pages/John-Sansom/128927867170307 style=text-decoration:none; target=_blank title=Facebook> <img height=64 src=https://www.johnsansom.com/wp-content/plugins/social-stickers/themes/default/facebook.png width=64> </a> <a onclick="_gaq.push(['_trackEvent', 'SocialButton', 'Click', 'Linkedin']);"href=https://linkedin.com/in/johnsansom style=text-decoration:none; target=_blank title=Linkedin> <img height=64 src=https://www.johnsansom.com/wp-content/plugins/social-stickers/themes/default/linkedin.png width=64> </a> <a onclick="_gaq.push(['_trackEvent', 'SocialButton', 'Click', 'RSS']);"href=https://www.johnsansom.com/rss style=text-decoration:none; target=_blank title=RSS> <img height=64 src=https://www.johnsansom.com/wp-content/plugins/social-stickers/themes/default/rss.png width=64> </a></div></div></section></div></div></header><nav aria-label=Main class=nav-primary itemscope itemtype=https://schema.org/SiteNavigationElement><div class=wrap><ul class="menu genesis-nav-menu menu-primary"id=menu-main-menu><li class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-14753"id=menu-item-14753><a href=https://www.johnsansom.com/about/ itemprop=url> <span itemprop=name> About </span> </a> <ul class=sub-menu><li class="menu-item menu-item-type-custom menu-item-object-custom menu-item-14754"id=menu-item-14754><a href=https://www.johnsansom.com/start-here/ itemprop=url> <span itemprop=name> The Blog </span> </a><li class="menu-item menu-item-type-post_type menu-item-object-page menu-item-14756"id=menu-item-14756><a href=https://www.johnsansom.com/about/ itemprop=url> <span itemprop=name> John Sansom </span> </a><li class="menu-item menu-item-type-post_type menu-item-object-page menu-item-14755"id=menu-item-14755><a href=https://www.johnsansom.com/contact-me/ itemprop=url> <span itemprop=name> Contact </span> </a></ul><li class="menu-item menu-item-type-post_type menu-item-object-page menu-item-73620"id=menu-item-73620><a href=https://www.johnsansom.com/dba-jumpstart/ itemprop=url> <span itemprop=name> Ebook </span> </a><li class="menu-item menu-item-type-custom menu-item-object-custom menu-item-has-children menu-item-14752"id=menu-item-14752><a href=https://www.johnsansom.com/archives/ itemprop=url title=Archives> <span itemprop=name> Archives </span> </a> <ul class=sub-menu><li class="menu-item menu-item-type-post_type menu-item-object-page menu-item-11126"id=menu-item-11126><a title="Start Here"href=https://www.johnsansom.com/start-here/ itemprop=url> <span itemprop=name> Start Here </span> </a><li class="menu-item menu-item-type-post_type menu-item-object-page menu-item-6934"id=menu-item-6934><a title="Popular Posts"href=https://www.johnsansom.com/popular-sql-server-posts/ itemprop=url> <span itemprop=name> Popular Posts </span> </a><li class="menu-item menu-item-type-custom menu-item-object-custom menu-item-14771"id=menu-item-14771><a href=https://www.johnsansom.com/archives/#all_posts itemprop=url> <span itemprop=name> All Posts </span> </a><li class="menu-item menu-item-type-post_type menu-item-object-page menu-item-7186"id=menu-item-7186><a title="Your weekly round-up of SQL Server Links"href=https://www.johnsansom.com/sftw/ itemprop=url> <span itemprop=name> SFTW </span> </a></ul><li class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-6935"id=menu-item-6935><a title="How To Become a SQL Server DBA"href=https://www.johnsansom.com/how-to-become-a-sql-server-dba/ itemprop=url> <span itemprop=name> Becoming a DBA </span> </a> <ul class=sub-menu><li class="menu-item menu-item-type-custom menu-item-object-custom menu-item-14757"id=menu-item-14757><a href=https://www.johnsansom.com/how-to-become-a-sql-server-dba/#whats_it_really_like itemprop=url> <span itemprop=name> What it’s Really Like </span> </a><li class="menu-item menu-item-type-custom menu-item-object-custom menu-item-14759"id=menu-item-14759><a href=https://www.johnsansom.com/how-to-become-a-sql-server-dba/#interviewing itemprop=url> <span itemprop=name> Interview Tips </span> </a><li class="menu-item menu-item-type-custom menu-item-object-custom menu-item-14758"id=menu-item-14758><a href=https://www.johnsansom.com/how-to-become-a-sql-server-dba/#certification itemprop=url> <span itemprop=name> Certification </span> </a><li class="menu-item menu-item-type-custom menu-item-object-custom menu-item-14761"id=menu-item-14761><a href=https://www.johnsansom.com/how-to-become-a-sql-server-dba/#faq itemprop=url> <span itemprop=name> FAQ </span> </a></ul><li class="menu-item menu-item-type-post_type menu-item-object-page menu-item-7699"id=menu-item-7699><a title="SQL Server Books"href=https://www.johnsansom.com/books/ itemprop=url> <span itemprop=name> Books </span> </a><li class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-6936"id=menu-item-6936><a href=https://www.johnsansom.com/sql-server-resources/ itemprop=url> <span itemprop=name> Resources </span> </a> <ul class=sub-menu><li class="menu-item menu-item-type-post_type menu-item-object-page menu-item-14218"id=menu-item-14218><a href=https://www.johnsansom.com/blogging-tools-technology/ itemprop=url> <span itemprop=name> Blog Tools and Technology </span> </a><li class="menu-item menu-item-type-post_type menu-item-object-page menu-item-7182"id=menu-item-7182><a href=https://www.johnsansom.com/uk-sql-server-events/ itemprop=url> <span itemprop=name> UK Events Schedule </span> </a><li class="menu-item menu-item-type-custom menu-item-object-custom menu-item-8548"id=menu-item-8548><a href=https://www.johnsansom.com/sql-server-resources itemprop=url> <span itemprop=name> References & Resource Lists </span> </a></ul><li class="menu-item menu-item-type-post_type menu-item-object-page menu-item-13144"id=menu-item-13144><a href=https://www.johnsansom.com/subscribe/ itemprop=url title=Subscribe> <span itemprop=name> Subscribe </span> </a></ul></div></nav><div class=site-inner><div class=content-sidebar-wrap><main class=content><article aria-label="The Database Administrator’s Primary Responsibility"class="post-987 post type-post status-publish format-standard category-database-administration category-disaster-recovery category-professional-development category-ssc-syndication category-sqlserverpedia-syndication tag-data-loss entry"itemscope itemtype=https://schema.org/CreativeWork><header class=entry-header><h1 class=entry-title itemprop=headline>The Database Administrator’s Primary Responsibility</h1><p class=entry-meta><time class=entry-time datetime=2009-07-20T07:24:55+01:00 itemprop=datePublished> July 20, 2009 </time> by <span class=entry-author itemprop=author itemscope itemtype=https://schema.org/Person> <a class=entry-author-link href=https://www.johnsansom.com/author/admin/ itemprop=url rel=author> <span class=entry-author-name itemprop=name> John Sansom </span> </a> </span> <span class=entry-comments-link> <a href=https://www.johnsansom.com/the-database-administrators-primary-responsibility/#comments> <span data-dsqidentifier="987 https://www.johnsansom.com/?p=987"class=dsq-postid> 45 Comments </span> </a> </span></header><div class=entry-content itemprop=text><div class=CBD_ad style=float:right;margin:5px;></div><p>You’re busy coding away at your workstation when all of a sudden your manager walks over to you all excited and begins discussing with you, the details of this great new application your company has just aquired. It turns out that he wants you to look after and administer this newly aquired application platform, which by the way, has a SQL Server engine.<p>You’re a natural when it comes to solving problems and you think you can handle it for sure, that is until slowly but surely it dawns on you that you have never actually had to administer a SQL Server database server before. In fact, you’re not even sure where you should begin.<p>Well fear not my friend! Whether you are an accidental DBA, just getting started with learning SQL Server technology or perhaps you just want to polish up on the basics. This is the first in a series of blog posts just for you guys and girls that want to get up to speed on the essentials of SQL Server, the core stuff that you just absolutely must know.<p>So with no time to loose, let’s get started…..<h2>What is the primary and most important responsibility of a SQL Server Database Administrator?</h2><p>Before you even go anywhere near a keyboard or launch SQL Server Management Studio, the first lesson that you absolutely must take on board is that the primary responsibility of a SQL Server database administrator is <em> “data” </em> .<h2>What’s so special about data?</h2><p>Data is arguably the most valuable asset of a business. It is the lifeblood of the organisation, whithout which it cannot function. As a SQL Server database administrator you have to safeguard your data.<p>The variety of information that data can describe is possibly limitless, with each variety just as important as the next, to the business it belongs to. Some examples of information that data may be used to describe include:<ul><li>An Application Backend/Data store<li>Storing and collecting vast amounts of data from the Large Hardron Collider at <a href=https://public.web.cern.ch/public/ title=CERN> CERN </a> or Modelling the <a href=http://www.ornl.gov/sci/techresources/Human_Genome/home.shtml> human genome </a><li>Customer/Client Contact Details<li>Financial Information / Banking Systems / Credit Card Processing<li>Company Sales Figures<li>Order Inventory System<li>Website Content<li>Train Timetables / Aircraft Reservation<li>Library / DVD / Car Rental</ul><p>The list is, as I’m sure you can imagine, potentially infinte. What should be immediately clear to you however, is that if anything bad were to happen to your data, for example a <em> data loss event </em> were to occur, it would almost certainly have a negative impact to the business. Possibly even serious enough to result in closure. Seriously this can and unfortunatly does happen!<div class="wp-caption alignnone"style="width: 160px"id=attachment_1013><img class="size-thumbnail wp-image-1013"alt=YourFired aria-describedby=caption-attachment-1013 height=150 loading=lazy src=https://www.johnsansom.com/wp-content/uploads/2009/07/YourFired-150x150.jpg title=YourFired width=150><p class=wp-caption-text id=caption-attachment-1013>“You’re Fired!”</div><p>Do <strong> NOT </strong> let <a href=http://www.techcrunch.com/2009/03/23/online-backup-company-carbonite-loses-customers-data-blames-and-sues-suppliers/> this </a> happen to you.<h2>Data Loss Event Types</h2><p>To give you an idea of what you’re going to be up against, consider that <a title="Wikipedia:Data Loss Events"href=https://en.wikipedia.org/wiki/Data_loss> Wikpedia </a> categorises <em> data loss events </em> into 5 main categories:<p> <ul><li><em> Intentional Action </em> <ul><li>Intentional deletion of a file or program</ul><li><em> Unintentional Action </em> <ul><li>Accidental deletion of a file or program<li>Misplacement of CDs or floppies<li>Administration errors<li>Inability to read unknown file format</ul><li><em> Failure </em> <ul><li><a title="Power failure"href=https://en.wikipedia.org/wiki/Power_failure> Power failure </a> , resulting in data in volatile memory not being saved to permanent memory.<li>Hardware failure, such as a <a title="Head crash"href=https://en.wikipedia.org/wiki/Head_crash> head crash </a> in a hard disk.<li>A software <a title="Crash (computing)"href=https://en.wikipedia.org/wiki/Crash_%28computing%29> crash </a> or freeze, resulting in data not being saved.<li>Software bugs or poor <a href=https://en.wikipedia.org/wiki/Usability title=Usability> usability </a> , such as not confirming a file delete command.<li><a title="Data corruption"href=https://en.wikipedia.org/wiki/Data_corruption> Data corruption </a> , such as filesystem corruption or database corruption.</ul><li><em> Disaster </em> <ul><li><a title="Natural disaster"href=https://en.wikipedia.org/wiki/Natural_disaster> Natural disaster </a> , <a href=https://en.wikipedia.org/wiki/Earthquake title=Earthquake> earthquake </a> , <a href=https://en.wikipedia.org/wiki/Flood title=Flood> flood </a> , <a href=https://en.wikipedia.org/wiki/Tornado title=Tornado> tornado </a> , etc.<li><a href=https://en.wikipedia.org/wiki/Fire title=Fire> Fire </a></ul><li><em> Crime </em> <ul><li>Theft, hacking, sabotage, etc.<li>A malicious act, such as a <a title="Computer worm"href=https://en.wikipedia.org/wiki/Computer_worm> worm </a> , <a title="Computer virus"href=https://en.wikipedia.org/wiki/Computer_virus> virus </a> , <a title="Hacker (computer security)"href=https://en.wikipedia.org/wiki/Hacker_%28computer_security%29> hacker </a> or theft of physical media.</ul></ul><h2>Understanding your responsibility</h2><div class="wp-caption alignnone"style="width: 160px"id=attachment_1015><img alt="The weight of the world on your shoulders"class="size-thumbnail wp-image-1015"aria-describedby=caption-attachment-1015 height=150 loading=lazy src=https://www.johnsansom.com/wp-content/uploads/2009/07/worldonyourshoulders-150x150.jpg title=worldonyourshoulders width=150><p class=wp-caption-text id=caption-attachment-1015>“The weight of the world on your shoulders”</div><p>I want you to sit back and to take a moment to think about what it is that you are about to become responsible for.<p>Make no mistake, as a SQL Server database administrator it is <strong> YOU </strong> who is responsible for safeguarding the database data. Your actions could be what makes the difference between a <em> data loss event </em> being fatal to your business or merely just a nuissance.<h2>What can I do to look after my data?</h2><p>Now that you know the Database Administrator’s primary responsibility is the data in their custody, what with all these potential risks vying to get at your precious data, what can you do to defend yourself?<p>Find out in Part 2 where we will look at the SQL Server database administrator’s most formidable defence method and discuss <a title="Why You Should be Using the FULL Recover Model"href=https://www.johnsansom.com/why-you-should-be-using-the-full-recovery-model/> <em> Why you should be using the FULL Recovery Model </em> </a> for your databases.<p>Have you got a tale to tell about <em> data loss </em> ? Please feel free to share your thoughts using the comments box below.<div style=clear:both;></div></div><footer class=entry-footer><p class=entry-meta><span class=entry-categories> Filed Under: <a rel="category tag"href=https://www.johnsansom.com/category/database-administration/> Administration </a> , <a rel="category tag"href=https://www.johnsansom.com/category/database-administration/disaster-recovery/> Disaster Recovery </a> , <a rel="category tag"href=https://www.johnsansom.com/category/professional-development/> Professional Development </a> , <a rel="category tag"href=https://www.johnsansom.com/category/ssc-syndication/> SQLServerCentral Syndication </a> , <a rel="category tag"href=https://www.johnsansom.com/category/sqlserverpedia-syndication/> SQLServerPedia Syndication </a> </span> <span class=entry-tags> Tagged With: <a href=https://www.johnsansom.com/tag/data-loss/ rel=tag> Data Loss </a> </span><div align=center><script async src=//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js></script><ins class=adsbygoogle data-ad-client=ca-pub-7223339800149227 data-ad-slot=1965997546 style=display:inline-block;width:336px;height:280px> </ins><script>(adsbygoogle = window.adsbygoogle || []).push({});</script></div></footer></article><section class=author-box itemprop=author itemscope itemtype=https://schema.org/Person><img class="avatar avatar-70 photo"srcset="https://secure.gravatar.com/avatar/ca22b1b0cfb92c112387be24fdee6dda?s=140&d=mm&r=g 2x"alt height=70 loading=lazy src=https://secure.gravatar.com/avatar/ca22b1b0cfb92c112387be24fdee6dda?s=70&d=mm&r=g width=70><h4 class=author-box-title>About <span itemprop=name> John Sansom </span></h4><div class=author-box-content itemprop=description><p>I’m a Microsoft Certified Master(MCM) of SQL Server. I’ve been working with database technology in a variety of flavors for over fifteen years. I absolutely love what I do and genuinely feel privileged to be a part of our tremendous technology community. Got a question about SQL Server or being a DBA? <a href=https://www.johnsansom.com/contact-me/> Ask me! </a></div></section><div id=disqus_thread></div></main><aside aria-label="Primary Sidebar"class="sidebar sidebar-primary widget-area"itemscope itemtype=https://schema.org/WPSideBar role=complementary><section class="widget ClickBombDefense_widget"id=clickbombdefense><div class=widget-wrap><div align=center><style>.sidebar-top-responsive { width: 300px; height: 250px; }
@media(max-width: 1024px) { .sidebar-top-responsive { width: 250px; height: 250px; } }
@media(max-width: 768px) { .sidebar-top-responsive { width: 200px; height: 200px; } }</style><script async src=//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js></script><ins class="adsbygoogle sidebar-top-responsive"data-ad-client=ca-pub-7223339800149227 data-ad-slot=5429624742 style=display:inline-block> </ins><script>(adsbygoogle = window.adsbygoogle || []).push({});</script></div></div></section><section class="widget widget_search"id=search-3><div class=widget-wrap><form class="searchform search-form"action=https://www.johnsansom.com/search><input class="s search-input"onblur="if (this.value == '') {this.value = 'Search this website';}"onfocus="if (this.value == 'Search this website') {this.value = '';}"value="Search this website"name=q><input class="searchsubmit search-submit"type=submit value=Search></form></div></section><section class="widget popular-posts"id=wpp-4><div class=widget-wrap><h4 class="widget-title widgettitle">Popular Articles</h4><ul class=wpp-list><li><a class=wpp-post-title href=https://www.johnsansom.com/top-10-free-sql-server-tools/> Top 10 Free SQL Server Tools </a><li><a class=wpp-post-title href=https://www.johnsansom.com/fast-sql-server-delete/> Performing fast SQL Server delete operations </a><li><a class=wpp-post-title href=https://www.johnsansom.com/how-to-identify-the-most-costly-sql-server-queries-using-dmvs/> How to identify the most costly SQL Server queries using DMV’s </a><li><a class=wpp-post-title href=https://www.johnsansom.com/top-10-junior-dba-interview-tips/> Top 10 Junior DBA Interview Tips </a><li class=current><a class=wpp-post-title href=https://www.johnsansom.com/the-database-administrators-primary-responsibility/> The Database Administrator’s Primary Responsibility </a><li><a class=wpp-post-title href=https://www.johnsansom.com/your-road-to-becoming-a-dba/> Your Road to Becoming a DBA: Laying a Strong Foundation </a><li><a class=wpp-post-title href=https://www.johnsansom.com/top-5-sql-forums/> Top 5 SQL Forums </a><li><a class=wpp-post-title href=https://www.johnsansom.com/script-sql-server-agent-jobs-using-powershell/> Script SQL Server Agent Jobs Using PowerShell </a><li><a class=wpp-post-title href=https://www.johnsansom.com/10-character-traits-of-outstanding-dbas/> 10 Character Traits of Outstanding DBA’s </a><li><a class=wpp-post-title href=https://www.johnsansom.com/sql-server-memory-configuration-determining-memtoleave-settings/> SQL Server Memory Configuration, Determining MemToLeave Settings </a></ul></div></section><section class="widget widget_text"id=text-450931281><div class=widget-wrap><div class=textwidget><div align=center><a href=https://thomaslarock.com/rankings/ rel=nofollow> <img src=https://www.johnsansom.com/wp-content/images/badge_model-169x200.jpg> </a></div></div></div></section><section class="widget widget_categories"id=categories-2><div class=widget-wrap><h4 class="widget-title widgettitle">Categories</h4><ul><li class="cat-item cat-item-7"><a href=https://www.johnsansom.com/category/database-administration/> Administration </a> (38)<li class="cat-item cat-item-161"><a href=https://www.johnsansom.com/category/professional-development/blogging/> Blogging </a> (8)<li class="cat-item cat-item-153"><a href=https://www.johnsansom.com/category/professional-development/customer-service-professional-development/> Customer Service </a> (5)<li class="cat-item cat-item-9"><a href=https://www.johnsansom.com/category/database-administration/disaster-recovery/> Disaster Recovery </a> (5)<li class="cat-item cat-item-18"><a href=https://www.johnsansom.com/category/database-administration/dynamic-management-views-dmv/> DMVs </a> (4)<li class="cat-item cat-item-10"><a href=https://www.johnsansom.com/category/database-administration/index-optimisation/> Index Optimisation </a> (6)<li class="cat-item cat-item-227"><a href=https://www.johnsansom.com/category/professional-development/interviews/> Interviews </a> (1)<li class="cat-item cat-item-171"><a href=https://www.johnsansom.com/category/sql-community/link-posts/> Link Posts </a> (243)<li class="cat-item cat-item-14"><a href=https://www.johnsansom.com/category/database-administration/memory/> Memory </a> (2)<li class="cat-item cat-item-11"><a href=https://www.johnsansom.com/category/performance-tuning/> Performance Tuning </a> (15)<li class="cat-item cat-item-15"><a title="Everything you wanted to know about being a modern and successful data professional."href=https://www.johnsansom.com/category/professional-development/> Professional Development </a> (70)<li class="cat-item cat-item-12"><a href=https://www.johnsansom.com/category/database-administration/reporting-services/> Reporting Services </a> (5)<li class="cat-item cat-item-162"><a href=https://www.johnsansom.com/category/sql-community/reviews/> Reviews </a> (1)<li class="cat-item cat-item-19"><a title="Everything to do with the awesome SQL Server community including news, events, weekly blog post roundups, user groups, twitter and much more."href=https://www.johnsansom.com/category/sql-community/> SQL Server Community </a> (144)<li class="cat-item cat-item-5"><a href=https://www.johnsansom.com/category/database-administration/sql-server-tips/> SQL Server Tips </a> (11)<li class="cat-item cat-item-117"><a href=https://www.johnsansom.com/category/ssc-syndication/> SQLServerCentral Syndication </a> (112)<li class="cat-item cat-item-91"><a title="Blog content that is syndicated to SQLServerPedia"href=https://www.johnsansom.com/category/sqlserverpedia-syndication/> SQLServerPedia Syndication </a> (116)<li class="cat-item cat-item-3"><a href=https://www.johnsansom.com/category/database-administration/tools/> Tools </a> (7)</ul></div></section><section class="widget widget_text"id=text-450931277><div class=widget-wrap><div class=textwidget><div align=center><script async src=//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js></script><ins class=adsbygoogle data-ad-client=ca-pub-7223339800149227 data-ad-slot=7602231942 style=display:inline-block;width:160px;height:600px> </ins><script>(adsbygoogle = window.adsbygoogle || []).push({});</script></div></div></div></section></aside></div></div></div><footer class=site-footer itemscope itemtype=https://schema.org/WPFooter><div class=wrap><div class=creds><p>Copyright © 2021 · <a href=http://www.santechsolutions.co.uk> Santech Solutions Limited </a> · Powered by the <a href=https://www.shareasale.com/r.cfm?b=346198&u=853678&m=28169&urllink=&afftrack=> Genesis Framework </a> · <a class="iubenda-nostyle no-brand iubenda-embed"title="Privacy Policy"href=https://www.iubenda.com/privacy-policy/686924> Privacy Policy </a> <script>(function (w,d) {var loader = function () {var s = d.createElement("script"), tag = d.getElementsByTagName("script")[0]; s.src = "https://cdn.iubenda.com/iubenda.js"; tag.parentNode.insertBefore(s,tag);}; if(w.addEventListener){w.addEventListener("load", loader, false);}else if(w.attachEvent){w.attachEvent("onload", loader);}else{w.onload = loader;}})(window, document);</script></div><p></div></footer><div class=AW-Form-1694728672></div><script>(function(d, s, id) {
    var js, fjs = d.getElementsByTagName(s)[0];
    if (d.getElementById(id)) return;
    js = d.createElement(s); js.id = id;
    js.src = "https://forms.aweber.com/form/72/1694728672.js";
    fjs.parentNode.insertBefore(js, fjs);
    }(document, "script", "aweber-wjs-piuby9hr4"));</script><script id=regenerator-runtime-js src=https://www.johnsansom.com/wp-includes/js/dist/vendor/regenerator-runtime.min.js?ver=0.13.7></script><script id=wp-polyfill-js src=https://www.johnsansom.com/wp-includes/js/dist/vendor/wp-polyfill.min.js?ver=3.15.0></script><script id=contact-form-7-js-extra>/* <![CDATA[ */
var wpcf7 = {"api":{"root":"https:\/\/www.johnsansom.com\/wp-json\/","namespace":"contact-form-7\/v1"}};
/* ]]> */</script><script id=contact-form-7-js src=https://www.johnsansom.com/wp-content/plugins/contact-form-7/includes/js/index.js?ver=5.4.2></script><script id=disqus_count-js-extra>/* <![CDATA[ */
var countVars = {"disqusShortname":"johnsansom"};
/* ]]> */</script><script id=disqus_count-js src=https://www.johnsansom.com/wp-content/plugins/disqus-comment-system/public/js/comment_count.js?ver=3.0.22></script><script id=disqus_embed-js-extra>/* <![CDATA[ */
var embedVars = {"disqusConfig":{"integration":"wordpress 3.0.22"},"disqusIdentifier":"987 https:\/\/www.johnsansom.com\/?p=987","disqusShortname":"johnsansom","disqusTitle":"The Database Administrator\u2019s Primary Responsibility","disqusUrl":"https:\/\/www.johnsansom.com\/the-database-administrators-primary-responsibility\/","postId":"987"};
/* ]]> */</script><script id=disqus_embed-js src=https://www.johnsansom.com/wp-content/plugins/disqus-comment-system/public/js/comment_embed.js?ver=3.0.22></script><script id=comment-reply-js src=https://www.johnsansom.com/wp-includes/js/comment-reply.min.js?ver=5.8.1></script><script id=google-recaptcha-js src=https://www.google.com/recaptcha/api.js?render=6Lcvl2kUAAAAAPioklyuAsLiQ4v4JN7bnXPi53da&ver=3.0></script><script id=wpcf7-recaptcha-js-extra>/* <![CDATA[ */
var wpcf7_recaptcha = {"sitekey":"6Lcvl2kUAAAAAPioklyuAsLiQ4v4JN7bnXPi53da","actions":{"homepage":"homepage","contactform":"contactform"}};
/* ]]> */</script><script id=wpcf7-recaptcha-js src=https://www.johnsansom.com/wp-content/plugins/contact-form-7/modules/recaptcha/index.js?ver=5.4.2></script><script id=wp-embed-js src=https://www.johnsansom.com/wp-includes/js/wp-embed.min.js?ver=5.8.1></script>