Microsoft SQL Server 2008 high availability

Description

If you are an SQL Server developer, system administrator, or even novice DBA, this book is for you. You only need a basic understanding of how SQL Server works to get you through the installation of SQL Server HA. With clear step-by-step instructions, real-world examples, and plenty of screenshots, this book provides all the support and guidance you will need as you install SQL Server HA options. It starts with an introductory chapter about the Windows domain, domain users, and the handshake methods available with Windows server and covers the different authentication methods available with SQL Server, giving you an insight into the importance of security. Then your journey to installing SQL Server HA starts, covering the concepts of database mirroring, log shipping, clustering, and replication. One appendix covers troubleshooting common issues you may encounter while installing or managing the HA options in your environment; a second appendix provides references to external resources.