Overview/Description
Database maintenance is an ongoing task for SQL Server 2008 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 Transact-SQL provides DBCC statements, which in turn provide 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. 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.
Target Audience
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.
Prerequisites
One to two years of experience using SQL Server 2008 or two to three years of experience using a previous version of SQL Server