Course 10156: Automating Administrative Tasks in Microsoft SQL Server 2008

Introduction This two-hour course provides you with the skills and knowledge required to automate administrative tasks in SQL Server 2008. You will learn how to configure SQL Server Agent and use the maintenance wizard and plans to create jobs. You will also learn how to automate tasks in a multi-server environment and configure SQL Server security.

Topics covered in this course include:

• Automating Administrative Tasks
• Configuring SQL Server Agent
• Creating Jobs and Operators
• Creating Alerts
• Managing Multiple Servers

Student prerequisites:

To benefit from this course, the learner must be familiar with using Microsoft Windows. They must have knowledge of basic relational database concepts and querying data by using Transact-SQL. They must be familiar with the role of a database administrator.
Objectives At the end of the course, students will be able to:

• Automate administrative tasks in SQL Server 2008.
• Configure SQL Server Agent.
• Create jobs and operators.
• Create alerts.
• Manage multiple servers.

Modules & Lessons Course Overview Module Overview Navigation Overview Navigation Overview Course Information Course Information Automating Administrative Tasks in Microsoft SQL Server 2008 Module Overview Automating Administrative Tasks Introduction The Benefits of Automation Using the Maintenance Plan Wizard Using Maintenance Plans Describing the SQL Server Agent Self Test Configuring SQL Server Agent Introduction Considerations for Configuring SQL Server Agent SQL Server Agent Roles Configuring Database Mail Configuring the SQL Server Agent Self Test Creating Jobs and Operators Introduction Describing Jobs Describing Operators Creating Operators Creating and Managing Jobs and Job Steps SQL Server Agent Proxy Accounts Using Job Activity Monitor and View the Job History Self Test Creating Alerts Introduction What Are Alerts? Creating SQL Server Alerts and Alert Responses Self Test Managing Multiple Servers Introduction Using Multiserver Administration How to Create Master and Target Servers Using Event Forwarding Configuring Event Forwarding Self Test Best Practices Best Practices Lab: Automating Administrative Tasks in Microsoft SQL Server 2008 Lab Overview Scenario Exercise Information Launch the Lab Lab Review Module Summary Module Summary Glossary Glossary System Requirements To view this course, you need:

• A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
• Microsoft® Windows® 2000 or higher
• Microsoft Internet Explorer 6.0 or higher
• Adobe Flash 7.0 or higher (1MB disk space needed to install)
• Microsoft Silverlight 4.0 or higher
• Microsoft Windows Media Player 7.0 or higher
• Microsoft XML Core Services 3.0 or higher
• A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
• A sound card, and either speakers or headphones (for multi-media audio).
• Internet bandwidth of 56K or faster. Broadband internet access is recommended.

For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:

• Microsoft Virtual Server ActiveX control (1MB disk space needed to install)

Test your computer's capabilities to see if it supports this course. Accessibility Requirements The following software must be running on your computer in order to access this course with Screen Reader Software:

• Microsoft Internet Explorer 6.0 or higher
• Window-Eyes from GW Micro
• JAWS from Freedom Scientific
• MSAA enabled