Category Archives: SQL Server Installation

Installing SQL Server 2012


One of the new feature with SQL Server 2012 is that it can be installed on a Server core machine. For the first time I am installing SQL Server  2012 on a Server core machine. I am using the configuration … Continue reading

Posted in Deployment, HyperV, Just Learned, SQL Server, SQL Server Installation, SQL2012, TestLab | Tagged , , , , | Leave a comment

Add Disk to Server Core Machine


I spend over two hours to configure the additional disk in my Server Core machine, so I thought of documenting the same. I had added a 10GB vhd to my server core machine, and was trying to configure it. Although … Continue reading

Posted in Deployment, How To, Just Learned, SQL Server, SQL Server Denali CTP1, SQL Server Installation, SQL2012, TestLab | Tagged , , , , | 1 Comment

Installation of SQL Server Enterprise Edition on Windows XP


I may be the last person to write about it; but yes, SQL Server 2008 Enterprise Edition can be installed on a client OS like Windows XP/Vista/7 etc. Many times, when I saw a post in the MSDN forums on … Continue reading

Posted in How To, SQL Server, SQL Server Installation | Leave a comment

Building a SQL Server 2008 R2 Cluster: Part VIII


As discussed in the previous part of this series, in a production environment you should never shut down a cluster as it failed the entire purpose of High Availability. However, the current series is focusing on learning purpose. If you … Continue reading

Posted in Clustering, How To, SQL Server, SQL Server HA, SQL Server Installation | Tagged , , , | 2 Comments

Buliding a SQL 2008 R2 Cluster: Part VII


In the previous part of this series, we had installed the Failover SQL Cluster. In this post, we are going to add the second node to the existing cluster. To begin with, verify that all the resources are present on … Continue reading

Posted in Clustering, How To, SQL Server, SQL Server HA, SQL Server Installation | Tagged , , | 1 Comment

Building a SQL Server 2008 R2 Cluster: Part VI


With Part-V of this series on Failover Cluster installation, the two-nodes windows 2008 cluster is up and running. Before continuing further, there is a small update on the installation prerequisites of SQL Server 2008 R2. The following three components are … Continue reading

Posted in Clustering, How To, SQL Server, SQL Server HA, SQL Server Installation | Tagged , , | 2 Comments

Building a SQL Server 2008 R2 Cluster: Part V


In the previous part of this series, we have created the windows cluster and added the disk resources. In this post, we are going to re-configure the Quorum setting of this cluster, and then we are going to add the … Continue reading

Posted in Clustering, How To, SQL Server, SQL Server HA, SQL Server Installation | Tagged , , | 5 Comments