Summary
Log shipping and database mirroring provide two key elements in the high available solution that Microsoft SQL Server offers. They are resilient and easy to set up, and offer a good price point in the overall choices you have. The key is that these are individual technologies that need to fit within the context of the overall SLA with the business units. Business users do not care how fast the database can failover if the overall ERP system does not come up at all in a catastrophe.
These technologies are just that; they provide parts of a solution and are not ends in themselves. Other parts of a highly available system are backups, clustering of the database server, redundancy in controllers, disk RAID levels, and so on. The recovery of ...
Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
