13-    Database Mirroring

Overview of Database Mirroring

-          Operating Modes of Database Mirroring

-          Database Mirroring Example

-          Database Mirroring and SQL Server 2008 Editions

-          Database Mirroring Catalog Views

-          Database Mirroring Role Change

-          Database Availability Scenarios

Monitoring Database Mirroring

-          Monitoring Using System Monitor

-          Monitoring Using Database Mirroring Monitor

-          Setting Thresholds on Counters and Sending Alerts

-          Monitoring Using SQL Profiler

Troubleshooting Database Mirroring

-          Troubleshooting Setup Errors

-          Troubleshooting Runtime Errors

-          Automatic Page Repair

Preparing the Mirror Server for Failover

-          Hardware, Software, and Server Configuration

-          Database Availability During Planned Downtime

-          SQL Job Configuration on the Mirror

-          Database TRUSTWORTHY Bit on the Mirror

-          Client Redirection to the Mirror

Mirroring Multiple Databases

Database Mirroring and Other High-Availability Solutions

-          Database Mirroring and Clustering

-          Database Mirroring and Transactional Replication

-          Database Mirroring and Log Shipping

Mirroring Event Listener Setup

Database Snapshots

 

14-    Backup and Recovery

Types of Failure

-          Hardware Failure

-          User Error

-          Application Failure

-          Software Failure

-          Too Much Privilege

-          Local Disasters

 

Making Plans

-          Backup/Recovery Plan

-          Maintaining the Plan

 

Overview of Backup and Restore

-          How Backup Works

-          Backup Compression

-          How Restore Works

-          Comparing Recovery Models

-          Choosing a Model

-          Switching Recovery Models

-          Verifying the Backup Images

-          Backing Up History Tables

-          Permissions Required for Backup and Restore

-          Backing Up System Databases

-          Full-text Backup

 

Planning for Recovery

-          Recoverability Requirements

-          Data Usage Patterns

-          Maintenance Time Window

-          Other High-Availability Solutions

 

Developing and Executing a Backup Plan

-          Using SQL Server 2008 Management Studio

-          Database Maintenance Plans

-          Using Transact-SQL Backup Commands

 

Managing Backups

Backup and Restore Performance

Performing Recovery

-          Restore Process

-          SQL Server Management Studio Restore

-          T-SQL Restore Command

-          Restoring System Databases

 

Archiving Data

-          SQL Server 2008 Table Partitioning

-          Partitioned View

 

Disaster Recovery Planning

 

15-    SQL Server 2008 Log Shipping

 

Log Shipping Deployment Scenarios

-          Log Shipping Deployment Scenarios

-          Log Shipping As a Disaster Recovery Solution

-          Log Shipping As a Report Database Solution

 

Log-Shipping Architecture

-          Primary Server

-          Secondary Server

-          Monitor Server

 

Log Shipping Process

System Requirements

-          Network

-          Identical Capacity Servers

-          Storage

-          Monitor Server

-          Software

 

Deploying Log Shipping

-          Initial Configuration

-          Deploying with Management Studio

-          Deploying with T-SQL Commands

 

Monitoring and Troubleshooting

-          Monitoring with Management Studio

-          Monitoring with Stored Procedures

-          Troubleshooting Approach

 

Managing Changing Roles

-          Synchronizing Dependencies

-          Switching Roles from the Primary to Secondary Servers

-          Switching Between Primary and Secondary Roles

-          Redirecting Clients to Connect to the Secondary Server

 

Database Backup Plan

Integrating Log Shipping with Other High-Availability Solutions

-          SQL Server 2008 Data Mirroring

-          Windows Failover Clustering

-          SQL Server 2008 Replication

 

Removing Log Shipping

-          Removing Log Shipping with Management Studio

-          Removing Log Shipping with T-SQL Commands

 

Log-Shipping Performance