Groups | Blog | Home


Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
all groups > sql server clustering > august 2006 > threads for august 15 - 21, 2006

Filter by week: 1 2 3 4 5

SQL 2005 Cluster install error "The drive specified cannot be used for program location"
Posted by Karl Kroneck at 8/21/2006 8:15:13 PM
When we try to install SQL 2005 on a two node cluster with iSCSI NetApp-Storage (Cluster is up and running), setup fails with the following error message: "The drive specified cannot be used for program location. Program files must be installed on a valid local disk available on all cluster...more >>


Recreating SQL cluster resources
Posted by Nuevo at 8/21/2006 4:26:27 PM
I had an issue with the SAN drivers for my SQL cluster and although I did not lose any data I lost all the SQL cluster resources (drives, IP addresses etc). Is there a way to repair or reinstall the cluster resources using setup or some other manner? Thanks. ...more >>

number of nodes
Posted by SalamElias at 8/20/2006 7:14:02 AM
Is there a doc describing max number of nodes per sql 2005 version. Is it correct that SQL2005 standard can support 4 nodes cluster Thanks...more >>

How to install SP to 1 node only
Posted by davidbuyuse at 8/17/2006 12:35:43 PM
How I can install service packs to 1 node only without affect the other node? I remember there is a registry change for that, but can not find it. Thank you!...more >>

Unable to run SQL agent after failover
Posted by stephanie at 8/16/2006 8:25:01 PM
Hi all, I failed failover to a secondary node and found that the sql agent was 'disabled' in the secondary node. However, in cluster admin and SQL Server configuration Manager, it shows the SQL Agent is running. Also, there is no error message in event viewer. BTW, I can't found the manag...more >>

Globally separated cluster
Posted by justinjmiller NO[at]SPAM gmail.com at 8/16/2006 6:31:49 PM
I am trying to plan a SQL Server 2005 cluster across multiple data centers around the world. Basically the database backs a load balanced web application. Each site has its own set of web servers and its own database servers but the databases must be in sync around the world so minimal downti...more >>

Is Active/Active Cluster (2 Nodes, 4 Processors each) on SQL Server '05 Standard Ed Supported?
Posted by maria.d.stone NO[at]SPAM gmail.com at 8/16/2006 12:58:31 PM
I have a new a two node cluster (each node with four dual-core processors) on 2003 Enterprise OS that will host a new SQL Server 2005 environment. Four Standard Edition processor licenses were already purchased for the new environment. The cluster was intended to run Active/Passive, but I have...more >>

Are multiple-instances on a single cluster supported with SQL Server 2005 Standard Edition?
Posted by maria.d.stone NO[at]SPAM gmail.com at 8/16/2006 12:47:56 PM
I had previously read a thread on this newsgroup stating multiple instances were not supported on a single cluster with SQL Server '05 Standard Edition. I'm researching information to take to the business for why we need SQL Server 2005 Enterprise Edition instead of Standard Edition. This is ...more >>



Moving virtual servers and named instances from a Win2000 to Win2003 cluster
Posted by Crispin38 at 8/16/2006 2:33:19 AM
I currently have a Win2000 cluster (2-nodes) with virtual servers\instances SQL1\SQL1 and SQL2\SQL2. What I want to do is move both to a Win2003 cluster (2-nodes). The catch here is that the Win2000 cluster is running on a SAN that does not support Win2003 hosts. I setup the new Win2003 clust...more >>

sql cluster server configuration utility shows blank data
Posted by bpilak at 8/15/2006 12:00:00 AM
Hi there, We are facing an issue with the failover cluster of sql server 2000 sp4. It is running on a windows 2003 server with sql server 2000 sp4 and clustered [build 2187] memory 64 GB Error causing sql restart is: ---------------------------------------------------------------------...more >>


DevelopmentNow Blog