Tag: sql-server-availability-groups

PostReviewing the Windows Event Logs to Find Hints That Can Cause Availability Issues

SQL Server Failover Clustered Instances (FCI) and Availability Groups (AG) depend a lot on Windows Server Failover Clustering (WSFC). Understanding how the underlying WSFC platform works can help us maintain availability of our databases [callout]This blog post is the third in a series that talks about the process that I follow when troubleshooting availability of SQL Server failover clustered […]

PostReviewing the SQL Server Error Logs to Find the Two Most Common Keywords That Can Cause Availability Issues

SQL Server Failover Clustered Instances (FCI) and Availability Groups (AG) depend a lot on Windows Server Failover Clustering (WSFC). Understanding how the underlying WSFC platform works can help us maintain availability of our databases [callout]This blog post is the second in a series that talks about the process that I follow when troubleshooting availability of SQL Server failover clustered instances and […]

PostThe Feature Was There All Along

SQL Server Availability Groups have been around for a while. But not a lot of organizations have implemented them yet mainly because they haven’t upgraded their database platforms to SQL Server 2012/2014. As more and more organizations move away from older versions and into the newer ones, Availability Groups will become much more common. And […]

PostMuch Ado About DNS

SQL Server Availability Groups have been around for a while. But not a lot of organizations have implemented them yet mainly because they haven’t upgraded their database platforms to SQL Server 2012/2014. As more and more organizations move away from older versions and into the newer ones, Availability Groups will become much more common. And […]

PostWhen A Log Backup Does Not Truncate Your SQL Server Log Files In An Availability Group

There are only two ways that can truncate your SQL Server log files – a checkpoint process when the database is in simple (or pseudo-simple) recovery model or a log backup when the database is in full or bulk-logged recovery models. In order for log truncation to occur, the virtual log files (VLFs) need to […]

PostWhy We Need To Understand How Active Directory Affects SQL Server High Availability

But I’ll tell you what hermits realize. If you go off into a far, far forest and get very quiet, you’ll come to understand that you’re connected with everything. – Alan Watts – WARNING: There will be a ton of acronyms in this blog post. Make sure to keep your notebook handy for note-taking reference. […]

Copyright © 2020 Learn SQL Server High Availability & Disaster Recovery

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close