New Microsoft SQL Server Video Tutorial: Pt 1 - Introduction to SQL Server 2005 Maintenance Plans

Pt 1 - Introduction to SQL Server 2005 Maintenance Plans - view details

Maintenance Plans (and the Maintenance Plan Wizard) are not new in SQL Server; Microsoft introduced Maintenance Plans in SQL Server 7.0 as a great way to automatically schedule common DBA tasks such as backups. In SQL Server 2005, Microsoft has really listened to its customers and vastly improved the Maintenance Plans (and wizard). If you've used Maintenance Plans in the past, things have changed considerably but for the good.

This video walks you through (1) what maintenance plans are, (2) launching the Maintenance Plan Wizard, and the basic choices of the wizard. There are so many choices in the Maintenance Plan Wizard that this video can only cover so many; the remaining videos of the series will help you walk through all of the choices in the maintenance plans. This particular video focuses on the "Check Database Integrity" choice including a walk-through of DBCC CHECKDB and what impact selecting this option may have on your server and a discussion on how often you'll want to schedule this option.

Another option covered in this video is the "Shrink Database" task along with Scott Whigham's discussion of Best Practices for shrinking databases.

• Category: Automating SQL Server: SQL Server Agent, Jobs, Email, Alerts and Scheduling
• Skill Level: 100 (Beginner)
• Length: 12:11 (11.2MB)
• Applies to Versions: SQL Server 2005
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required

Note: You must have the TSCC codec installed to view this video