Microsoft® SQL Server® 2012 Bible

707 Chapter 27: Database Mirroring 27 Monitoring Using System Monitor Apart from using the Database Mirroring Monitor, you can a ...

708 Part V: Enterprise Data Management Monitoring Using SQL Server Profi ler To capture the time taken for database mirroring fa ...

709 Chapter 27: Database Mirroring 27 ALTER DATABASE AdventureWorks SET PARTNER SUSPEND; To resume the database mirroring sessio ...

710 Part V: Enterprise Data Management The default timeout for communication between the principal, mirror, and witness servers ...

711 Chapter 27: Database Mirroring 27 mirror role but the database mirroring session is suspended. To resume the database mirror ...

712 Part V: Enterprise Data Management ■ (^) No requirement for a witness server to achieve high-availability/automatic failover ...

713 Chapter 27: Database Mirroring 27 ■ (^) Each computer participating in an availability group must be part of the same Window ...

714 Part V: Enterprise Data Management FIGURE 27-14 Overview of a WSFC cluster with an AlwaysOn Availability Group. Node 1 Windo ...

715 Chapter 27: Database Mirroring 27 Failover Cluster Validation Report The validation checks can complete successfully; howeve ...

716 Part V: Enterprise Data Management Next, the wizard validates your selections and presents you with a confi rmation screen ...

717 Chapter 27: Database Mirroring 27 Now that you created your WSFC cluster, you must set up your availability group in SQL Ser ...

718 Part V: Enterprise Data Management database meets the prerequisites to be a member of the availability group. If there are a ...

719 Chapter 27: Database Mirroring 27 Commit (supports up to three replicas in a group). You can also specify if the replica is ...

720 Part V: Enterprise Data Management FIGURE 27-20 Specifying backup preferences for your replicas. Click the Listener tab. He ...

721 Chapter 27: Database Mirroring 27 availability group. If you select this option, you must also specify a fi le share on the ...

722 Part V: Enterprise Data Management FIGURE 27-22 Setting up initial synchronization of databases. FIGURE 27-23 Scripting Out ...

723 Chapter 27: Database Mirroring 27 When completed, you can see your newly confi gured availability group in Management Studio ...

724 Part V: Enterprise Data Management FIGURE 27-25 Availability group details page. The availability replica details pane has t ...

725 Chapter 27: Database Mirroring 27 Also from this page you can access the following from the links in the top-right side of t ...

c27.indd 726c27.indd 726 7/31/2012 9:50:34 AM7/31/2012 9:50:34 AM http://www.it-ebooks.info ...