Examines the detailed configuration and the internal workings of the different replication types using real–life scenarios
Covers replication with database mirroring and troubleshooting
Discusses replication administration using different tools
What you’ll learn
Configure hierarchical replication: snapshot, transactional and merge, and heterogeneous replication using real–life scenarios.
Gain insight into the internal workings of the different replication types.
Master the usage of different tools like tablediff, SQLCMD, DTA, and Replication Monitor in administering replication.
Perform administration tasks such as backup and recovery, and manage replication with other high–availability techniques like database mirroring and log shipping.
Conduct optimization and tuning of replicated databases.
Develop troubleshooting techniques.