Summary

The role of the DBA is to provide a reliable database environment. Businesses are requiring that systems be up and available 24/7.

The DBA needs to understand the options for the database system to provide high availability. This includes knowing the resource costs for each solution and what type of availability it provides.

Making a case for how a high-availability solution improves the management and reliability of the database, as well as provides for the needs of the business, is the responsibility of the DBA. Implementing, deploying, and administering the environment is the fun part for the DBA.

SQL Server has high-availability solutions that you might have considered and/or implemented. The options for SQL Server do not behave the ...

Get Oracle Database Administration for Microsoft SQL Server DBAs 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.