Tags » AlwaysOn

SQL 2016 Automatic Seeding of Availability Groups

–By Lori Brown

I came across something today that I did not know existed in AG’s, Automatic Seeding. This allows SQL to automatically create the secondary replicas for all databases in an AG. 325 more words

SQL Server

Introduction to AlwaysOn Availability Group (AAG) and configuration.

The ‘Always On Availability Groups’ feature is a high-availability and disaster-recovery solution that combines the capabilities of ‘Fail-Over Clustering’, ‘Database Mirroring’, ‘Log shipping… 1,048 more words

Microsoft SQL Server

Hybrid: SQL AlwaysOn Availability Group

Giải pháp AlwaysOn Availability Group luôn cung cấp cho một nhóm database của bạn tính sẵn sàng cao bằng cách thêm vào 1 bản sao chép. 1,284 more words


Windows Cluster LOG ERR [RCM] [GIM] ResType Virtual Machine has no resources

While reviewing my cluster log on Node A, I found the error: ERR   ResType Virtual Machine has no resources, not collecting local utilization info

Short Answer: If there is no Hyper-V this error can be ignored. 181 more words

SQL Server

AlwaysOn availability groups

Always on Availability groups offer the best in redundancy offered by Microsoft.  They are rock solid, relatively straightforward, and can be set up by a good DBA in hours. 25 more words


Failover Time-Prediction

In the previous post, we learned the basic definition of SQL’s new feature AlwaysOn and the various events that occur when a failover happens.

Today, we will learn how SQL Database engine predicts the time involved during the failover which can be very helpful for deciding the… 756 more words


AlwaysOn Failover Cluster- Explanation

To Start learning about the new SQL Server 2012 feature AlwaysOn lets start with basic study about the Windows Server Failover Clustering.

WSFC is a server feature which is used for the high availability for the critical applications. 333 more words