SQL Server Best Practices Article
Published: January 10, 2008
Writer: Sanjay Mishra
Contributors: Prem Mehra, Lindsey Allen
Reviewers: Matt Hollingsworth, Juergen Thomas, Mark Souza, Burzin Patel, Tom Michaels, Raffaella Canobbio, Steve Lindell, Kevin Farlee, Mark Scurrell, Michael Redman, Michael Thomassy, Mike Ruthruff, Thomas Davidson
Log shipping and database mirroring can work together to provide solutions for high availability and disaster recovery. You can convert an existing log shipping configuration to a database mirroring configuration. Although Microsoft only supports a single mirror database, you can set up log shipping from a database mirroring pair to additional servers, to provide multiple failover sites. Moreover, you can easily switch which pair of instances is using database mirroring and which instances are configured with log shipping.
For more information, please refer to the Database Mirroring and Log Shipping Working Together whitepaper.
|
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
|
|
