Last week I was pretty much focusing on setting a lab environment to test SQL 2012 Availability Groups and Failover Cluster Instances. I had to setup 3 VM’s to play…
There should be a definite plan to implement a cluster upgrade,and its important to have a proper checklist for the same: 1. Take database backup’s including system databases. 2. Script out all…
Today I faced a situation where new LUN’s where added to a server and SQL was clustered on top of windows cluster. I wanted to use the new LUN’s to…
For the SQL Server resource we need to add a dependency of the drive to which we are moving the database and log files. 1. Right click the SQL…