Module 6: Back up & Recovery - 1 Day (6 hours) |
Planning for and recovering from disasters
- Transaction log architecture
- Choosing a recovery model
- Performing full, log and differential backups
- Recovering system and user databases
Implementing database mirroring
- Selecting a mirroring architecture
- Configuring the mirror and witness servers
- Monitoring database mirroring
- Taking a snapshot of the mirror
Practice Exam
- Interview questions and answers discussion
- Written test
- Oral presentation test
|
Module 7: Automating Tasks with Jobs and Alerts - 1 Day (6 hours) |
The SQL Server Agent
- Configuring the Agent
- Setting up Database Mail
Multistep jobs
- Defining jobs to handle routine tasks
- Creating alerts and operators
- Associating alerts with jobs
Practice Exam
- Interview questions and answers discussion
- Written test
- Oral presentation test
|
Module 8: Deploying Replication - 1 Day (6 hours) |
Replication Concepts
- Publish/subscribe metaphor
- Replication types
- Replication agents
Managing transactional replication
- Configuring the Publisher and Distributor
- Creating publications
- Subscribing to publications
Practice Exam
- Interview questions and answers discussion
- Written test
- Oral presentation test
|
Module 9: Monitoring SQL Server - 1 Day (6 hours) |
- Identifying problems with Activity Monitor
- Querying Dynamic Management Objects
- Deploying the Performance Dashboard
- Analyzing trends with the SQL Server Health and History tool (SQLH2)
Practice Exam
- Interview questions and answers discussion
- Written test
- Oral presentation test
|
