Microsoft® SQL Server® 2012 Bible

727 CHAPTER 28 Replicating Data IN THIS CHAPTER Understanding Replication Concepts Confi guring Replication R eplication is a na ...

728 Part V: Enterprise Data Management ■ (^) Triggers ■ Copy Database Wizard ■ (^) Backup and restore ■ Log shipping and databas ...

729 Chapter 28: Replicating Data 28 Copy Database Wizard The Copy Database Wizard can move or copy a database from one server to ...

730 Part V: Enterprise Data Management What’s New with Replication in SQL 2012? There are two new features in SQL Server 2012 re ...

731 Chapter 28: Replicating Data 28 ■ (^) Peer-to-peer replication: Another variant of transactional replication used to rep- li ...

732 Part V: Enterprise Data Management the publisher’s values for the row with a primary key (PK) of 1,000 on the publisher and ...

733 Chapter 28: Replicating Data 28 The task to use the wizard to confi gure it across the environments could be just as painful ...

734 Part V: Enterprise Data Management importance. There is a warning on this screen simply stating that the default loca- tion ...

735 Chapter 28: Replicating Data 28 When you get to the option to select which server you want to use as your distribu- tor, se ...

736 Part V: Enterprise Data Management If you highlight a table and then click the Article Properties drop-down box, you can con ...

737 Chapter 28: Replicating Data 28 Using the SQL Server Agent account is not considered to be a good security practice because ...

738 Part V: Enterprise Data Management FIGURE 28-2 The Snapshot Agent Security dialog. After you create your publication, you ca ...

739 Chapter 28: Replicating Data 28 Click Next to advance to the Subscribers dialog. All subscribers currently enabled appear i ...

74 0 Part V: Enterprise Data Management Click Next to advance to the Wizard options. Here you can specify whether you want the ...

741 Chapter 28: Replicating Data 28 When this is done, follow these steps to set up a peer-to-peer topology: Return to the publ ...

742 Part V: Enterprise Data Management columns that you want to replicate. The Article Properties button enables you to control ...

74 3 Chapter 28: Replicating Data 28 ■ (^) The other difference is that you can add a value for hostname that supplies a value t ...

74 4 Part V: Enterprise Data Management Summary Replication is a complex and powerful feature of SQL Server, and fully describin ...

74 5 CHAPTER 29 Clustering IN THIS CHAPTER Understanding High Availability vs. Scale Out Understanding Clustering Installing SQL ...

74 6 Part V: Enterprise Data Management High Availability versus Scale Out Clustering in Windows and with SQL Server 2012 is pri ...