SQL Server Best Practices Article
Published: January 10, 2008Writer: Sanjay MishraContributors: Prem Mehra, Lindsey AllenReviewers: 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.
Building and Deploying Large Scale SQL Server Reporting Services Environments Technical Note Series Authors
Pingback from ?????? ???????????????? ???? SSWUG, ?????? ?????????? ???????????? ???????????????? ??-DB, ???? ?????????????????? ???????? ??-Oracle Open World ???????? ?????????? - SQLServer.co.il
All the solutions mentioned on http://sqlcat.com are Excellent! Thanks for all the information.