The goal of the DBA Virtual Group is to provide a PASS community for the DBA. It provides a forum for open discussion and education on issues that face SQL Server database administrators.

Designing Custom Maintenance Plans using the Ola Hallengren Scripts – sponsored by Dell Softwa

Wed, Jan 22 2014 17:00 UTC

Designing Custom Maintenance Plans using the Ola Hallengren Scripts – sponsored by Dell Software

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! We will investigate how to build a custom maintenance plans from the ground up using Ola’s scripts as a starting point. What are the best practices for daily, weekly and monthly tasks? This presentation includes tape rotation schemes and restoring those backups to make sure they really work. Outline 1 – How to install the Ola Hallengren scripts. 2 – Identifying system versus user databases. 3 – Coming up with a backup schedule based on size (full, diff, log) and business requirements. 4 – Various backup options (verify, checksum, compression, cleanup, copy only,). 5 – Backup read/write file groups only for data warehouse systems. 6 – Advanced options to speed up the backup (file striping, buffer count, max transfer size). 7 – One missing option I would like to see added is ‘MIRROR TO’. 8 – Why backup to disk then swipe to tape? 9 – Known tape rotations. The ‘Tower of Hanoi’ versus ‘Grandfather-Father-Son’. 10 – Checking the integrity of your database. 11 - Intelligent Index Maintenance; Reorganize versus Rebuild. 12 – Updating statistics on your table. 15 – Using the restore command for FILELIST ONLY (information) and VERIFY ONLY (integrity) options. 14 – How do I restore my database? 15 – Testing your backups via monthly restores. 16 – What is a tail backup? When is it used during an outage? 17 – How to do a point in time recovery? 18 – What are the best practices for daily, weekly and monthly tasks?


John Miner

John has over twenty years of IT experience including a Masters degree in Computer Science from the University of Rhode Island with concentrations in database technologies and programming languages. He also has Microsoft Certificates for Database Administration (MCDBA) and System Admistration (MCSA). John is currently a Senior SQL Server Developer / Administrator in charge of best practices by the IT team at Sensata Technologies.

Interested in Presenting to the DBA VG?

We can always use people to give a talk at one of our bi-monthly events. If you are interested in giving a presentation, please send your title, a brief abstract and a brief bio to Sharon Dooley, dbavolunteer@sqlpass.org.

Want to become a member of the DBA VG Leadership team?

Members of this team moderate meetings and interact with the speakers during the Q&A sessions. Contact Sharon Dooley, dbavolunteer@sqlpass.org if you'd like to become part of the team.

Have a speaker to recommend?

Send the email address of the proposed speaker together with any relevant information about the speaker to Sharon Dooley, dbavolunteer@sqlpass.org.

 

Meeting Recordings

The DBA Virtual Chapter presentations are recorded. On the Meeting Archive page, you will find  .WMV files that can be viewed on-line. Select the event you are interested in, click the Show More button if it is visible, and the recording and any associated files will be visible.

Regular Meeting Schedule

The DBA Virtual Chapter holds two regular webinars each month. The first one is on the second Wednesday at noon, Mountain time and the second one is on the fourth Wednesday at noon, Eastern time. These 1 - 1¼ hour presentations include slides, demos and a time for questions and answers. The meetings are recorded and archived.

 

Follow us on Twitter: @PASS_DBA_VC

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids