Title: Maintenance Cleanup Task - SQL Server 2008 Maintenance plan - Lesson 2
Duration: 14:46 min
Summary: This lesson will show what is a database maintenance plan and how can you configure Maintenance Cleanup Task.
Methodology of the development of example: SQL Server provides a maintenance plan that help to implement appropriate measures to ensure that your database is safe and properly maintained. A Maintenance plan is useful to perform routine database administration tasks like checking database integrity, performing index maintenance, updating database statistics, performing database backup etc.So This lesson will show what is a database maintenance plan and how can you perform database Maintenance Cleanup Task using SQL Management Studio.
Technologies Used: Framework 3.5, SQL Server 2008 Management Studio
Examples constructed: Create a maintenance plan and Subtask.
Keywords: SQL Server 2008, Mainteinance Plan