Create SQL Server Availability Group (AG) cluster on Azure

Описание к видео Create SQL Server Availability Group (AG) cluster on Azure

This is a complete video on how to create SQL Server Availability Group cluster on Azure.

Chapters:
0:00 - Introduction
0:13 - Configure accounts in Domain
9:26 - Add accounts to replicas
16:19 - Install Windows Failover Clustering Features
17:40 - Set Firewall Rules
19:33 - Install Windows Failover clustering (WSFC)
22:30 - Add nodes to the cluster
23:52 - Enable AG cluster features
25:58 - Create AG database
26:30 - Create backup share location
28:50 - Create AG cluster in SSMS

The command used in the video while giving permission to NT AUTHORITY:
=================
USE [master]
GO
CREATE LOGIN [NT AUTHORITY\SYSTEM] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
GO

GRANT ALTER ANY AVAILABILITY GROUP TO [NT AUTHORITY\SYSTEM]
GO
GRANT CONNECT SQL TO [NT AUTHORITY\SYSTEM]
GO
GRANT VIEW SERVER STATE TO [NT AUTHORITY\SYSTEM]
GO

🚀►The prerequisite video on creating a domain:
   • Quickly create a domain on Azure Virt...  
📚 ►SQL Server internals:    • SQL Internals  
📷 ►Follow me on Instagram - https://www.instagram.com/arslanov_bo...
🧑‍💼►Follow me on LinkedIn -   / bobirmirzo-arslanov-548960173  

Watch all my playlists here:
🚀►Full course on Encrypting connections to SQL Server-    • Full course on Encrypting connections...  
🚀 ►SQL Server replication session:    • SQL Server replication  
🚀 ►SQL Server Always On Availability Group:    • SQL Server Always On Availability Gro...  
🚀 ► Full course on Troubleshooting sessions:    • Troubleshooting  
🚀 ► Course in On-memory OLTP:    • Course on In-Memory OLTP  

Комментарии

Информация по комментариям в разработке