{"id":383,"date":"2011-05-01T00:00:48","date_gmt":"2011-05-01T00:00:48","guid":{"rendered":"http:\/\/reservoirsw.com\/?p=383"},"modified":"2024-01-06T16:56:13","modified_gmt":"2024-01-06T16:56:13","slug":"may-2011-designing-custom-maintenance-plans-with-tsql-john-miner","status":"publish","type":"post","link":"https:\/\/snessug.craftydba.com\/?p=383","title":{"rendered":"May-2011 ~ Designing Custom Maintenance Plans with TSQL ~ John Miner"},"content":{"rendered":"<p><a href=\"https:\/\/snessug.craftydba.com\/wp-content\/uploads\/2012\/03\/spring_clipart_tulips.gif\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/snessug.craftydba.com\/wp-content\/uploads\/2012\/03\/spring_clipart_tulips.gif\" alt=\"\" title=\"spring\" width=\"125\" height=\"125\" class=\"alignleft size-full wp-image-176\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #800000;\">Presenter:<\/span>  John Miner of Sensata Technologies<br \/>\n<span style=\"color: #800000;\">Topic:<\/span> Designing Custom Maintenance Plans with TSQL<\/p>\n<p>&nbsp;<\/p>\n<p>Have you ever received a call from a client asking for help when their SQL Server database is corrupted? You suggest that they restore the database from the last good backup. There is a long pause on the phone as the client states that the only backups\/tapes they have are bad. Do not let this situation happen to you! <\/p>\n<p>This presentation will review how to build a custom maintenance plans from the ground up using TSQL commands. <\/p>\n<p>1. Verify integrity of databases. <\/p>\n<p>2. Backup databases (full versus differential). <\/p>\n<p>3. Backup logs <\/p>\n<p>4. Maintain database indexes. <\/p>\n<p>5. Maintain index\/column statistics. <\/p>\n<p>6. Remove older data from [msdb]. <\/p>\n<p>7. Remove older backups from file system. <\/p>\n<p>We will be reviewing best practices for daily, weekly and monthly tasks. This includes tape rotation schemes and restoring those backups to make sure they really work. <\/p>\n<p><span style=\"color: #800000;\">Biography:<\/span><\/p>\n<p>John Miner (craftydba.com) has twenty years of data processing and proven project management experience, specializing in the banking, health care, and government areas. His architecture expertise encompasses all phases of the project life cycle, including design, development, implementation, and maintenance. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Presenter: John Miner of Sensata Technologies Topic: Designing Custom Maintenance Plans with TSQL &nbsp; Have you ever received a call from a client asking for help when their SQL Server database is corrupted? You suggest that they restore the database from the last good backup. There is a long pause on the phone as [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[187],"tags":[72,6,74,75,12,73],"class_list":["post-383","post","type-post","status-publish","format-standard","hentry","category-2011-events","tag-backup","tag-dba","tag-maintain","tag-remove-old","tag-sql-server","tag-verify"],"_links":{"self":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/383","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=383"}],"version-history":[{"count":4,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/383\/revisions"}],"predecessor-version":[{"id":1164,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/383\/revisions\/1164"}],"wp:attachment":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=383"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=383"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=383"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}