Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction To The Course|
|Section 2: Database Maintenace Methodologies|
Why Perform Maintenance & Core Maintenance TasksPreview
|Section 3: Configuring SQL Server Agent|
Configuring Database Mail
Configuring SQL Server Agent To Use Database Mail
Configuring Operators And Alerts
Demo Of SQL Event Alert
Demo Of SQL Performance Alert
Configuring SQL Agent History Retention
|Section 4: Basic Maintenance Tasks|
Back Up Database Task - Full Backup
Back Up Database Task - Differential Backup
Back Up Database Task - Transaction Log Backup
Check Database Integrity Task
Rebuild Index TaskPreview
Reorganize Index Task
Update Statistics Task
|Section 5: Miscellaneous Maintenance Tasks|
Execute SQL Agent Job Task
Execute T-SQL Statement Task
History Cleanup Task
Maintenance Cleanup Task
Notify Operator Task
Shrink Database Task
|Section 6: Putting It All Together: Creating Maintenance Plans|
Database Maintenance Plan Wizard
Database Maintenance Plan Designer
|Section 7: Maintenance Plan Limitations And Alternatives|
Limitations Of Maintenance Plans
Maintenance Plan Alternatives
|Section 8: Course Wrap Up|
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.