SqlServer-QA.net

I was working recently with a customer who was looking to deploy a SQL Server 2005 cluster across 2 geographically dispersed sites using Windows Server 2008. They were looking to utilise the new clustering improvements in Windows Server 2008 to build a highly available SQL Server solution. The customer required automatic failover between the sites ...

IN continuation to the post Rollback_of_CumulativeUpdate-hotfix-ServicePack I was asked about any procedure or steps on installing Cumulative update package 7 for SQL Server 2005 Service Pack 2 on Active node SQL 2005 cluster. The simple answer is all of such hotfix/Service Pack/Cumulative Update packages are cluster-aware. That means when ...

A new Level 300 support webcast has been scheduled for Monday the 9th of June, 10:00 AM Pacific Time. The summary of the session is as follows: This Support WebCast focuses on how to plan, implement, and administer a Microsoft SQL Server 2005 failover cluster on Windows Server 2008. This session provides step-by-step instructions about how to ...

Windows Server 2008 is on full fledged wave now after it has been launched in February and it is obvious that many questions will be flying around about supportability & manageability for existing SQL Server versions such as 2005 at the moment. Think about managing the SQL Server 2005 Failover Clustering on the new Windows Server ...

The host node in the failover cluster performs a ''looks alive'' check every 5 seconds. An IsAlive check is performed every 60 seconds using SELECT @@SERVERNAME. If this fails the IsAlive retries 5 times and then attempts to reconnect to the instance of SQL. If all fail, then the SQL Server resource fails. Depending on the failover threshold, ...

First part of question is a pure newbie FAQ to know about, and the simple answer would be it is one of the Clustering type you can adopt within your SQL Server environment. To cover on newbie aspect both Active/Passive & Active/Active configuration is available within SQL Server, both operating system & SQL engine work together to ...

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 ...

Another FAQ within newsgroups & forums that will SQL Server Clustering supports load balancing? It is quite common for a newbie to say and look at Clustering configuration such as Active-Active where you have n+1 nodes as a serving instances, the only difference between Active-Passive configuration is having 2(+n) active nodes at a ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise X64 EditionNotification Contents: New and All Modifications A service pack does not install on a x64-based passive node cluster computer that is running SQL Server 2005http://support.microsoft.com/kb/929151/en-US

Upgrading a SQL Server database should be straight-forward, when you haven't got much of constraints on the application code.  In this regard we have blogged previously such as UpgradeTags posts. Here in this post I would like to go with few FAQs that are related to Upgrade process & procedure: Say you need to ...