SQL Server Maintenance Plans

Learn how to use SQL Server maintenance plans to perform common maintenance tasks against your databases.
4.5 (11 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
171 students enrolled
Instructed by Shaun Stuart Development / Databases
$40
Take This Course
  • Lectures 38
  • Contents Video: 2 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2014 English

Course Description

This course will teach you all about SQL Server's maintenance plans and what they can (and can't) do. The course starts out briefly covering SQL Server Agent and Database Mail, two components of SQL Server that work in concert with Maintenance Plans. Next, you'll learn about every option available in maintenance plans and how to configure each option. You'll then see video demonstrations that will walk you through every step in the process of creating a maintenance plan using two different methods. And finally, you'll learn the limitations of maintenance plans and where to go next when your systems grow to the point of requiring a more complex maintenance solution. The course is taught using SQL Server 2012, but the content is applicable to SQL 2008 R2, SQL 2008, and SQL 2005. The entire course is over 1.5 hours.

What are the requirements?

  • Basic knowledge of SQL Server Management Studio is helpful.

What am I going to get from this course?

  • By the end of this course, you will be able to create maintenance plans to keep your SQL Server databases running at peak efficency
  • You will be able to idenify which maintenance operations are well-suited for maintenance plans and whch are not
  • You will be able to identify when your environment has grown to the point where maintenance plans might no longer be the best maintenance option.

What is the target audience?

  • This course is intended for beginner to intermdiate level database administrators or those who must support a SQL Server environment but have little to no experience with SQL Server.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction To The Course
Instructor Details
Preview
00:38
Course Overview
Preview
00:45
Section 2: Database Maintenace Methodologies
Introduction
Preview
00:28
Why Perform Maintenance & Core Maintenance Tasks
Preview
00:57
Maintenance Plans
Preview
00:45
T-SQL Scripts
Preview
00:49
PowerShell Scripts
00:47
Summary
00:36
Section 3: Configuring SQL Server Agent
Introduction
00:42
Configuring Database Mail
09:42
Configuring SQL Server Agent To Use Database Mail
01:30
Configuring Operators And Alerts
05:06
Demo Of SQL Event Alert
04:48
Demo Of SQL Performance Alert
02:10
Configuring SQL Agent History Retention
02:32
Summary
00:40
Section 4: Basic Maintenance Tasks
Introduction
Preview
00:52
Back Up Database Task - Full Backup
09:05
Back Up Database Task - Differential Backup
02:09
Back Up Database Task - Transaction Log Backup
03:06
Check Database Integrity Task
02:20
Rebuild Index Task
Preview
05:49
Reorganize Index Task
02:00
Update Statistics Task
03:30
Section 5: Miscellaneous Maintenance Tasks
Introduction
Preview
00:26
Execute SQL Agent Job Task
00:48
Execute T-SQL Statement Task
01:35
History Cleanup Task
02:27
Maintenance Cleanup Task
03:24
Notify Operator Task
01:31
Shrink Database Task
05:01
Section 6: Putting It All Together: Creating Maintenance Plans
Introduction
00:27
Database Maintenance Plan Wizard
09:08
Database Maintenance Plan Designer
13:15
Section 7: Maintenance Plan Limitations And Alternatives
Introduction
00:36
Limitations Of Maintenance Plans
02:56
Maintenance Plan Alternatives
06:27
Section 8: Course Wrap Up
Summary
00:56

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Shaun Stuart, Senior SQL Server Database Administrator And Author

Shaun J. Stuart is a Database Administrator with over 15 years experience with SQL Server. He holds the following Microsoft certifications: MCTS: SQL Server 2005, MCTS: SQL Server 2008, MCITP: Database Administrator 2008, and MCSA: SQL Server 2012. He is the senior Database Administrator at the largest credit union in Arizona and a co-author of the book Tribal SQL: New Voices In SQL Server, published by Red Gate. He holds a Bachelors degree in electrical engineering.

Ready to start learning?
Take This Course