Category Archives: SQL Server Installation

Installing SQL Server 2012

Posted on March 14, 2012 by

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

Posted on March 12, 2012 by

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

Posted on June 28, 2011 by

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

Posted on February 2, 2011 by

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

Posted on February 1, 2011 by

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

Posted on January 31, 2011 by

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

Posted on November 24, 2010 by

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

Building a SQL Server 2008 R2 Cluster: Part IV

Posted on November 24, 2010 by

As of previous post, we have configured all the necessary parameters to start the Failover Cluster installation including dotnet framework 3.5. In this post, we are going to build the failover windows cluster on Windows Server 2008. I have started … Continue reading →

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

Building a SQL Server 2008 R2 Cluster: Part III

Posted on November 21, 2010 by

In the previous part of this post, we have configured the disks for our Windows Cluster. The disks are created from a RAID 5 LUN. As you can see, we have a LUN of 60GB however only 40GB is available … Continue reading →

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

Building a SQL Server 2008 R2 Cluster: Part II

Posted on November 17, 2010 by

In the first part of this series, we saw the installation of our storage server for our demo cluster environment. In this part, we are going to configure our storage server. Before we configure our storage server, we need to … Continue reading →

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