1z0-030 dumps 461
462 462
Improving Query 1z0-030 1z0-030 dumps pdf download Performance with Indexes Database Tuning Advisor Too Many Indexes? Summary
CHAPTER 15: REPLICATION
464 468 469 471
473
Replication Overview
Replication Components Replication Types Replication Enhancements in SQL Server 2012
473
474 476 478
Replication Models
Single Publisher, One or More Subscribers
478
478
xxvii
CONTENTS
Multiple Publishers, Single Subscriber Multiple Publishers Also Subscribing Updating Subscriber Peer-to-Peer
480 481 482 483
Implementing Replication
Setting Up Snapshot Replication Setting Up Distribution Implementing Snapshot Replication Implementing Transactional and Merge Replication
484
484 484 487 497
Peer-to-Peer Replication
Setting Up Peer-to-Peer Replication Configuring Peer-to-Peer Replication
498
498 499
Scripting Replication Monitoring Replication
Replication Monitor Performance Monitor Replication DMVs sp_replcounters
502 502
502 505 505 506
Summary
CHAPTER 16: CLUSTERING SQL SERVER 2012
507
509
Clustering and Your Organization
What Clustering Can Do What Clustering Cannot Do Choosing SQL Server 2012 Clustering for the Right Reasons Alternatives to Clustering
510
510 511 512 512
Clustering: The Big Picture
How Clustering Works Clustering Options
514
515 518
Upgrading SQL Server Clustering
Don’t Upgrade Upgrading Your SQL Server 2012 Cluster In Place Rebuilding Your Cluster Back-Out Plan Which Upgrade Option Is Best?
520
520 520 521 523 523
Getting Prepared for Clustering
Preparing the Infrastructure Preparing the Hardware
523
523 524
Clustering Windows Server 2008
Before Installing Windows 2011 Clustering Installing Windows Server 2008 Failover Clustering Preparing Windows Server 2008 for Clustering
xxviii
527
527 528 531
CONTENTS
Clustering Microsoft Distributed Transaction Coordinator Clustering SQL Server 2012
Step by Step to Cluster SQL Server Installing the Service Pack and Cumulative Updates Test, Test, and Test Again
532 534
534 540 540
Managing and Monitoring the Cluster Troubleshooting Cluster Problems
How to Approach Windows Failover Clustering Troubleshooting Doing It Right the First Time Gathering Information Resolving Problems Working with Microsoft
542 543
544 544 544 545 545
Summary
CHAPTER 17: BACKUP AND RECOVERY
546
547
Types of Failure
Hardware Failure 1z0-030 dumps 1z0-030 dumps pdf Data Modification Failure Software Failure Local Disasters
548
548 548 550 550
Making Plans
Backup/Recovery Plan Disaster Recovery Planning Creating the Disaster Recovery Plan Maintaining the Plan