SqlServer-QA.net

When you think about high availability in SQL Server then you would think about Clustering and in addition to this within 2005 version we have Database Mirroring too that can provide automated failover support to your database server applications. By default you can see a failover cluster as a combination of one or more nodes (servers) with two or ...

Before installing the SQL Server cluster there must be a checklist in order to ensure you haven't compromised on any hardcore requirement. In this regard Microsoft suggests the hardward that must be  listed on this  Windows Catalog and Hardware Compatibility, otherwise you may not be able to utilize or install full set of clustering ...

Few counters and gotchas for you to look for when you are installing SQL Server clusters, also using SELECT statements & DMVs to get SQL instance information. Such as: Do not install SQL Server on a compressed drive, by default the installation will fail. For naming the Cluster group within the failover cluster installation that ...

I know it sounds easy to upgrade a SQL Server Cluster environment from 2000 to 2005 version, as easy it mentioned within the Books Online for SQL Server 2005. When I have performed for the first time, my first thought was (do we need that or take out the reasons). But one thing is sure that SQL Server 2005 offers a number of ...

A common mistake by DBAs for missing to check whether all the functionality of tools are working when a SQL Server Cluster environment is setup, though you may not catch hold of few issues with basic failover/failback testing initially but when the application is initiated and data is stored with relevant scheduled jobs and processes the ...

Various options availability from the SQL Server using a Cluster and Standby server technologies, this whitepaper helps you to understand what best or solution can be applied to your business availability & continuity.