-
Continue reading →: SQL Server Services Status Using DMV’s – 2008R2 SP1/Denali
Today let’s see a new way to look at Installed SQL Services on your Server from T-SQL.Till SQL Server 2008 for verifying services status, service accounts, startup type etc..we’ve to go and verify from SQL Server Configuration manager as shown below. Starting SQL Server 2008R2 SP1 Microsoft introduced a new…
-
Continue reading →: Installing SQL Server 2008/2008R2 Failover Cluster- Part4
In the third part of this series InstallCluster-Part3, I’ve shown you how we can create a Domain/DNS and add rest of the Nodes to that domain, configuring NIC’s and all that Cool stuff. In this part of the series let’s see how can we configure our SAN. As I already…
-
Continue reading →: Installing SQL Server 2008/2008R2 Failover Cluster- Part3
This is the 3rd part of the SQL Cluster 2008 Installation Series. In the 2nd part InstallCluster-Part2 I’ve explained how to Install Windows Server 2008 on your Virtual Machine(s). In this part let’s try to configure our DC and join rest of the Nodes into our domain. why to wait, Let’s start!!…
-
Continue reading →: Installing SQL Server 2008/2008R2 Failover Cluster- Part2
In the previous post InstallCluster Part-1 I’ve discussed about what are required prerequisites and few best practices. Assuming you’ve downloaded all the required software’s and Operating System ISO(x86 or x64 depending on your CPU), let’s continue to install windows Server 2008 VM(s). Let’s install three VM’s in this 2nd part of series to…
-
Continue reading →: Installing SQL Server 2008/2008R2 Failover Cluster- Part1
This is the first part of the series “Installing SQL Server 2008/2008R2 Failover Cluster”. Let me ask you something first! Have you ever been in the situation where you want to explore about your cluster, but your hands were tied because of the Live Production Server? Raise your Hands Up…
