Tags » AlwaysOn

Manual Failover error on SQL Server 2014SP1 AlwaysOn

I implemented AlwaysOn Availability groups solution on SQL Server 2014 SP1.

During the testing of a manual failover (via the GUI), I encountered the following error: 239 more words


There have been lots of requests from community in Delhi to talk about HADR with SQL Server. Finally, we managed to get the event organized based on the theme of HADR using SQL 2016 AlwaysON. 524 more words

SQL DB Engine

Build your own SQL Server Playground Part 1 (Intro)

When I first started working with SQL server it was as a BI developer. This was fine and I learned a lot. But after a few years I wanted to learn more about performance of and high availability and so started my journey to DBA. 463 more words


Setup LAB: 06 Installing Windows Failover Cluster to setup AlwaysOn

In the last post, I had configured the iSCSI target service to share the disk between two servers. I am going to use those two servers as Windows server Failover Cluster nodes and setup AlwaysOn availability group using that. 291 more words

How To

SQL SERVER - How To Improve Performance by Offloading Backups to a Secondary Replica - Notes from the Field #108

: If we get one server, we want two servers, and if we get two servers, we want four servers. If we know we are going to get only two servers, we try our best to get maximum out of our available server. 679 more words

SQL Authority

Setup LAB: 05 Configuring the iSCSI Target

In the previous post, I had installed the iSCSI Target service and create the volume using File and Storage Service. In this post, let’s configure the iSCSI Target Service. 228 more words

How To

Setup LAB: 04 Setting up a Storage Server

Whenever we setup a Cluster in a LAB environment, often the biggest challenges in the whole process is, how to configure the storage server. A user reported that, the configuration steps mentioned on my… 398 more words

How To