From the course: Microsoft SQL Server 2016 Essential Training
Join today to access over 22,700 courses taught by industry experts or purchase this course individually.
Add a cleanup task to a maintenance plan - SQL Server Tutorial
From the course: Microsoft SQL Server 2016 Essential Training
Add a cleanup task to a maintenance plan
- [Instructor] In this section, we're going to look at modifying the maintenance plan that we created in the previous section. So, I'll go to that maintenance plan, right click on it, and go to Modify. This will pull up a little bit of a different interface. When we created the maintenance plan, we used a wizard, but when we modify it, we don't use a wizard, so the interface is a little different. We're going to use this main design window, and also the toolbox. If the toolbox didn't appear for you automatically, you can get it off the View menu, go to Toolbox, and here in the toolbox, we see a list of all the tasks that can be performed in a maintenance plan. The one I'm interested in is a cleanup task. This is going to go in and delete some of the old files, so I'm going to drag Maintenance Cleanup Task onto the main design surface. I'd like this cleanup task to run after the full database backup, so I'll click on the box that represents the Back Up Database Full task, then I'll…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.