{"id":6899,"date":"2014-01-09T00:00:54","date_gmt":"2014-01-09T00:00:54","guid":{"rendered":"http:\/\/craftydba.com\/?p=6899"},"modified":"2016-04-20T01:47:21","modified_gmt":"2016-04-20T01:47:21","slug":"designing-custom-maintenance-plans-using-the-ola-hallengren-scripts","status":"publish","type":"post","link":"https:\/\/craftydba.com\/?p=6899","title":{"rendered":"Custom Maintenance Plans using Ola Hallengren Scripts"},"content":{"rendered":"

I am looking forward to my first live presentation for the PASS Database Administration Virtual Chapter<\/a> next week. <\/p>\n

If you are interested in the topic, please register for the webinar on Wednesday, January 22, 2014 at Noon, Eastern Standard time. Registration<\/a> is required and you will be automatically entered in a raffle for a $50 Amazon gift card.<\/p>\n

Topic:<\/span><\/p>\n

Designing Custom Maintenance Plans using the Ola Hallengren Scripts<\/p>\n

Abstract:<\/span><\/p>\n

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. <\/p>\n

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

We will investigate how to build a custom maintenance plans from the ground up using Ola\u2019s scripts as a starting point. What are the best practices for daily, weekly and monthly tasks? <\/p>\n

This presentation includes tape rotation schemes and restoring those backups to make sure they really work. <\/p>\n

Some topics will be covered in depth while others will be given as homework.<\/p>\n

Coverage:<\/span><\/p>\n

1 \u2013 How to install the Ola Hallengren<\/a> scripts.<\/p>\n

2 \u2013 Identifying system versus user databases.<\/p>\n

3 \u2013 Coming up with a backup schedule based on size (full, diff, log) and business requirements.<\/p>\n

4 \u2013 Various backup options (verify, checksum, compression, cleanup, copy only, etc).<\/p>\n

5 \u2013 Backup read\/write file groups only for data warehouse systems.<\/p>\n

6 \u2013 Advance options to speed up the backup (file striping, buffer count, max transfer size).<\/p>\n

7 \u2013 One missing option I would like to see added is \u2018MIRROR TO\u2019.<\/p>\n

8 \u2013 Why backup to disk then swipe to tape? <\/p>\n

9 \u2013 Known tape rotations. The \u2018Tower of Hanoi\u2019 versus \u2018Grandfather-Father-Son\u2019.<\/p>\n

10 \u2013 Checking the integrity of your database.<\/p>\n

11 – Intelligent Index Maintenance; Reorganize versus Rebuild.<\/p>\n

12 \u2013 Updating statistics on your table.<\/p>\n

13 \u2013 Using the restore command for FILE LIST ONLY (information) and VERIFY ONLY (integrity) options.<\/p>\n

14 \u2013 How do I restore my database?<\/p>\n

15 \u2013 Testing your backups via monthly restores. <\/p>\n

16 \u2013 What is a tail backup? When is it used during a outage?<\/p>\n

17 \u2013 How to do a point in time recovery?<\/p>\n

18 \u2013 What are the best practices for daily, weekly and monthly tasks?<\/p>\n

Presentation Bundle<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

I am looking forward to my first live presentation for the PASS Database Administration Virtual Chapter next week. If you are interested in the topic, please register for the webinar on Wednesday, January 22, 2014 at Noon, Eastern Standard time. Registration is required and you will be automatically entered in a raffle for a $50 Amazon gift card. Topic: Designing Custom Maintenance Plans using the Ola Hallengren Scripts Abstract: Have you ever received a call from a client asking for help when their SQL Server database is corrupted? You suggest…<\/p>\n","protected":false},"author":1,"featured_media":6913,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[600],"tags":[1021,1022],"class_list":["post-6899","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-pres","tag-john-f-miner-iii--pass--presentation--webinar","tag-pass-dba-virtual-chapter"],"_links":{"self":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/6899","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6899"}],"version-history":[{"count":0,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/6899\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/media\/6913"}],"wp:attachment":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6899"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6899"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6899"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}