© Peter A. Carter 2020
P. A. CarterSQL Server 2019 AlwaysOnhttps://doi.org/10.1007/978-1-4842-6479-9_8

8. Administering AlwaysOn

Peter A. Carter1 
(1)
Botley, UK
 

This chapter will discuss how to administer AlwaysOn features. We will first look at cluster maintenance, including rolling patch upgrades and removing an instance. We will then discuss managing Availability Groups, including how to fail over synchronously and asynchronously. We will also examine how to fail over a Distributed Availability Group.

Additional maintenance tasks, such as synchronizing instance-level objects, safe-stating an application, and adding multiple Listeners to an Availability Group will also be discussed. The chapter will end by discussing how to suspend data movement ...

Get SQL Server 2019 AlwaysOn: Supporting 24x7 Applications with Continuous Uptime 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.