/*================================================================================== Curso: SQL SERVER 2019 https://www.udemy.com/course/draft/3957796/?referralCode=FB10D369E786D9FE8A48 Instrutor: Sandro Servino https://www.linkedin.com/in/sandroservino/?originalSubdomain=pt https://filiado.wixsite.com/sandroservino ==================================================================================*/ /*================================================================================== ATIVIDADES ROTINEIRAS BÁSICAS DO DBA Windows Failover Cluster e Always on ==================================================================================*/ -- AZURE -- instalacao always on e failover cluster e load balance na azure, passos. No caso das vms no azure o listener ip é guardado no load balance e por isto -- para usar listener em vms que estao na azure, precisa configurar o NLB (load balance) na azure. Segue os dois passos desde a premissa ser quiser configurar -- as VMS na azure. 1 https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/availability-group-manually-configure-prerequisites-tutorial Tutorial: Prerequisites for creating availability groups on SQL Server on Azure Virtual Machines 2 https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/availability-group-manually-configure-tutorial Tutorial: Manually configure an availability group (SQL Server on Azure VMs) ----------------------------- -- AWS https://aws.amazon.com/pt/premiumsupport/knowledge-center/ec2-windows-sql-server-always-on-cluster/