{"id":287,"date":"2015-02-22T14:05:15","date_gmt":"2015-02-22T21:05:15","guid":{"rendered":"http:\/\/s1095387061.online-home.ca\/?p=287"},"modified":"2015-02-22T14:11:03","modified_gmt":"2015-02-22T21:11:03","slug":"about-usefulness-of-trivial-tasks","status":"publish","type":"post","link":"https:\/\/databaserefresh.com\/blog\/about-usefulness-of-trivial-tasks\/","title":{"rendered":"About usefulness of trivial tasks"},"content":{"rendered":"<p>I just wanted to share a story that one of my friends-DBAs shared with me.<\/p>\n<p>So, they have internal DBAs responsible for the part of the environment and remote\/external DBAs that look after another part of the environment.<br \/>\nIn most cases these two groups do not look after each others environments and their responsibilities do not criss-cross. But my curious friend one day decided to do a little disk cleanup\/checkup (from the old backups etc.) and discovered that archive logs for one of the mission critical databases have not been cleaned up for a year. The database was under the external group supervision.<br \/>\nAfter a short investigation my friend discovered that the database didn&#8217;t have backups for a year!<\/p>\n<p>The moral is:<br \/>\n1) Even simple trivial tasks can sometimes help you to discover flows<br \/>\n2) Do not rely on third party contractors even if they have a very good reputation. Make an occasional checks. It wouldn&#8217;t heart to add a couple more servers to the monitoring.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I just wanted to share a story that one of my friends-DBAs shared with me. So, they have internal DBAs responsible for the part of the environment and remote\/external DBAs that look after another part of the environment. In most &hellip; <a href=\"https:\/\/databaserefresh.com\/blog\/about-usefulness-of-trivial-tasks\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"footnotes":""},"categories":[12,59,11,3],"tags":[],"class_list":["post-287","post","type-post","status-publish","format-standard","hentry","category-dba_checks","category-monitoring","category-sql_stories","category-sql_server"],"_links":{"self":[{"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/posts\/287","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/comments?post=287"}],"version-history":[{"count":5,"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/posts\/287\/revisions"}],"predecessor-version":[{"id":292,"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/posts\/287\/revisions\/292"}],"wp:attachment":[{"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/media?parent=287"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/categories?post=287"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/tags?post=287"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}