Published: August 2008 Writers: Gopal Ashok (Microsoft Corporation), Paul S. Randal (SQLskills.com) Reviewers: Hilary Cotter (Relevant Noise), Prem Mehra, Lindsey Allen, Sanjay Mishra, Glenn Berry (SQL Server MVP), Jimmy May, Mike Ruthruff, Michael Redman, Joseph Sack
This white paper describes how to use database mirroring to increase the availability of the replication stream in a transactional environment. It covers setting up replication in a mirrored environment, the effect of mirroring partnership state changes, and the effect of mirroring failovers on replication. In addition, it describes how to use LSN-based initialization to recover from the failover of a mirrored subscriber database.
Although brief overviews are given of both replication and database mirroring, it is easier to understand this white paper if the reader has some experience with one or both of these technologies, and has at least a rudimentary knowledge of database concepts such as transactions.
For more information, please refer to the whitepaper SQL Server Replication: Providing High Availability using Database Mirroring.
|
sql, server, best practices, whitepapers, analysis services, data mining, olap, datawarehouse, datawarehousing, availability, clustering, capacity, collation, data types, data warehouse, database, design, index, mirroring, optimization, partitions, performance, precision, processing, querying, scalability, security, reporting services, integration services
|
|