Successfully Implement SQL Server Always On Availability Groups with Failover Clustered Instances

Рет қаралды 434

Edwin M Sarmiento - SQL Server HA and DR

25 күн бұрын

This is a walk-through of building a SQL Server Always on Availability Group on top of a Failover Clustered Instance to achieve both local high availability and remote disaster recovery.
This is a complex architecture. Make sure you include everyone involved in designing, implementing, and managing it during the planning phase.
And while this video is less than an hour long, nobody builds this kind or architecture in less than an hour. Proper planning and implementation takes days and involves engineers with intermediate-level skills.
NOTE: I no longer recommend this architecture due to the complexity of the implementation. However, there are so many implementations like this in customer environments that were not done properly.
Download the Cluster Preparation Check list from here
learnsqlserverhadr.com/cluste...

Пікірлер: 5

@edgarallanbayron3924 7 күн бұрын

just in time. I needed this info and it was 2 weeks ago! Subbed now :) Need to watch more of your videos.

@AnandNarine 24 күн бұрын

what happens to the tlogs if the replica is offline? does it grow forever ?

@EdwinMSarmiento 23 күн бұрын

This happens 🙂 kzfaq.info/get/bejne/eLmDZ6phnZ25lYE.html I used this example to demonstrate the effects of tlogs growing and getting full until it can no longer do so. The application may throw an error that doesn't explicitly tell you it's a SQL Server problem.

@AnandNarine 23 күн бұрын

@@EdwinMSarmiento what can be done to reduce the size of it in this case?

@EdwinMSarmiento 23 күн бұрын

@@AnandNarine Monitor and take precautionary measures to make sure the tlog files do not grow to a size that fills up the disk. That really is all there is to it.