Title: Database maintenance - How can you
configure a good SQL Server - SQL Server 2008 Maintenance plan - Lesson 1
Duration: 14:11 min
Summary: This lesson will show what is a database maintenance plan and how can you configure a good SQL Server maintenance plan.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 backup using a good SQL Server maintenance plan
Technologies Used: Framework 3.5, SQL Server 2008 Management Studio.
Examples constructed: Create a maintenance plan and Subtask.
Keywords: SQL Server 2008, Maintenance Plan.