Overview/Description Target Audience Prerequisites Expected Duration Lesson Objectives Course Number Overview/Description
Database maintenance is an ongoing task for SQL Server 2008 R2 administrators. This requires the integrity of the database to be checked, the database size to be kept to a minimum by ensuring the files are the correct sizes, and maintenance tasks to be run regularly. SQL Server 2008 R2 Transact-SQL provides DBCC statements, which in turn provides statements to maintain the database and database files. An administrator can also use maintenance plans to run a series of tasks on specific databases using a schedule or on demand. This course demonstrates how to confirm the integrity of a database, manage database files, and how to create maintenance plans using a wizard or the designer. The course also addresses how to move data between SQL Server instances using detach and attach methods and the Copy Database Wizard, and how to move database files within the same SQL Server instance. SQL Server Agent and Policy-Based Management is also covered to demonstrate how to manage SQL Server 2008 R2. This course is one of a series in the SkillSoft learning path that covers the objectives for Microsoft SQL Server 2008 exam number 70-432. Passing this exam will earn the learner the Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation and Maintenance certification.
Professionals typically pursuing a career as a Database Administrator; individuals who don't work directly with SQL Server as part of their primary job but wish to show their breadth of technology experience, including developers and systems administrators.
One to two years of experience using SQL Server 2008, SQL Server 2008 R2, or two to three years of experience using a previous version of SQL Server