SQL Server 2008 Database Management

This course is included in our On-demand training solution.


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.


One to two years of experience using SQL Server 2008 or two to three years of experience using a previous version of SQL Server

Expected Duration

120 min.

Course Objectives

SQL Server 2008 Database Integrity and File Management

  • recognize how to check database integrity
  • recognize how to shrink a database
  • recognize how to expand a database
  • Moving Database Files in SQL Server 2008

  • recognize how to detach a database
  • recognize how to move a database between instances
  • Using Database Maintenance Plans in SQL Server 2008

  • recognize how to create database maintenance plans to automate administrative tasks
  • Managing Database Integrity and Using Maintenance Plans

    SQL Server Agent Security and Operator Configuration

  • recognize the purpose of SQL Server Agent
  • recognize how to use SQL Server Agent to create operators
  • Configuring SQL Server Agent Jobs and Alerts

  • recognize how to use a SQL Server Agent job to automate a task
  • recognize how to create an alert that responds to events that occur on a SQL Server computer
  • Policy-Based Management in SQL Server 2008

  • recognize how the Policy-Based Management feature works in SQL Server 2008
  • recognize how to use SQL Server 2008 Policy-Based Management to create a policy
  • Using SQL Server Agent and Policy-Based Management