Continuing from AlwaysOn Part 1 the series continues with a step-by-step guide to setting up the environment for an AlwaysOn availability group. In this article we will break down AlwaysOn environment preparation into three steps : Installation of SQL Server 2012 on each node/replica/server. Installation of the failover clustering feature on each node/replica/server. Creation of [...]

This is the first in a four-part series on the new AlwaysOn feature in SQL Server 2012. In this article, AlwaysOn is introduced and contrasted with previous high-availability solutions in SQL Server. The second part of the series will commence with a detailed walkthrough on preparing the environment for AlwaysOn. Prior to SQL Server 2012, [...]

We are unable to install SQL Server 2005 on additional node on top existing cluster setup running Windows 2003 x64 bit operating system? What is the usage of the WITNESS instance in SQL Server 2005 Database Mirroring?What are the specific tasks assigned to System Administrator (SA)role in SQL Server? How can I disable or rename [...]