Skip to content
  • Training
  • Consulting
  • First Responder Kit
  • Blog
    • Popular Topics
    • Well, Actually...
  • Videos
  • Log In
Newsletter

Backups 3: Setting Up Maintenance Plans

Developers and sysadmins: the easiest way for you to protect your servers is by using maintenance plans.

Full time production database administrators should watch the Ola Hallengren maintenance script setup module instead. I’m specifically targeting this video at developers and sysadmins who need an easy, safe way to protect stuff without knowing T-SQL.

DBA Fundamentals - Backups 3 - Setting Up Maintenance Plans

Backups 2: Restores Backups 4: Setting Up Ola Hallengren’s Maintenance Scripts

In this class

Fundamentals of Database Administration
  • Backups 1: 3 Common Strategies
  • Backups 2: Restores
  • Backups 3: Setting Up Maintenance Plans
  • Backups 4: Setting Up Ola Hallengren’s Maintenance Scripts
  • Backups: Reading from Databases During Restores
  • Configuration: Anti-Virus
  • Configuration: Instant File Initialization
  • Configuration: Lock Pages in Memory (LPIM)
  • Configuration: Prepare for Emergencies with the Remote DAC
  • Configuration: Sending Emails with Database Mail
  • Configuration: sp_configure Settings
  • Configuration: TempDB Files and Sizes
  • Corruption 1: How it Happens, and How to Detect It
  • Corruption 2: DBCC CHECKDB for VLDBs
  • Maintenance: Agent Jobs
  • Maintenance: Patches: Which Ones to Apply, When, and How
  • Maintenance: Shrinking Files

SQL Server training, consulting, and thousands of pages of free help.

Get the newsletter

Training

  • Live classes
  • Recorded classes
  • Corporate training
  • Log In

Free Help

  • First Responder Kit
  • Blog
  • Videos
  • Newsletter

Company

  • Consulting
  • About
  • Contact
© Brent Ozar Unlimited®. All rights reserved. · Privacy