Transcript Powerpoint - Chapter 16

Chapter Overview
•
Using Standby Servers
•
Using Failover Clustering
1
Standby Servers
•
A secondary server that is kept up to date with
the primary server
• Used in place of primary server in the event of
failure or when maintenance is required
•
Also used to offload reporting and analysis tasks
2
Steps to Promote a
Standby Server
3
Automatic Log Shipping
•
Available only with the Enterprise Edition.
•
Use the Database Maintenance Plan wizard to
create jobs.
•
Use alerts to notify administrators of log
shipping failures.
• Use a central monitoring server for monitoring
primary/standby server pairs.
4
Log Shipping Monitor
•
Located in the Management container in Microsoft
SQL Server Enterprise Manager on the monitoring
server
•
Displays the status of all log shipping pairs
•
Allows you to view backup history and
copy/restore history for each log shipping pair
•
Allows you to view properties of each log shipping
pair, including job frequencies and alert schedules
5
Promoting a Standby Server
•
sp_change_primary_role
•
sp_change_secondary_role
• sp_change_monitor_role
•
Create necessary logins
6
Microsoft Cluster Service
(MSCS)
7
SQL Server on a
Server Cluster
•
The Setup program installs a virtual server
across two or more nodes.
• An IP address (or addresses) is assigned to the
virtual server.
•
Executable files are installed on all nodes, and
data files are installed on the shared storage
system.
•
One node is primary; other nodes are passive to
this virtual server.
8
Cluster Types
•
Active/Passive
•
Active/Active
9
Planning Issues
•
Run Cluster wizard before install to use MS DTC.
•
Dynamic memory management.
• Set recovery interval to zero.
•
Change service account passwords with SQL
Server Enterprise Manager.
•
Use the shared disk for replication snapshot
files.
10
Disaster Recovery
•
Recovery of database occurs automatically.
•
Failover node takes over and handles all current
connections.
•
Run Setup program to remove failed node.
•
After repair, rerun Setup program and add the
rebuilt node.
11
Chapter Summary
•
Standby servers shorten the length of time
required to recover from a server failure.
• Log shipping automates the maintenance of a
standby server.
•
Server clusters provide the most rapid recovery
in the event of a server failure.
•
Choose either active/passive or active/active.
12