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 > march 2006 > threads for march 15 - 21, 2006

Filter by week: 1 2 3 4 5

Add SAN Disk Resource to Active/Active SQL cluster
Posted by theredmiata NO[at]SPAM hotmail.com at 3/21/2006 11:04:12 AM
Looking to see if I am missing any steps below to adding a SAN disk resource to an Active/Active SQL cluster: -Create Volumes -Present LUNs to both Nodes -Failover Cluster Groups to Node2 -On Node1 Disable ClusDisk Disable Cluster Services Reboot Node1 Rescan for hardware changes Wri...more >>


Stop SQL Server service without failing it over.
Posted by mostro at 3/20/2006 3:03:29 PM
I'm setting up SQL Mail with Outlook and need to restart the SQL services (mssqlserver and sql agent) on the server to complete the configuration. I would like to do this without causing a failover. Has anyone sucessfully used the commands below to make this work? System: Windows 2003, SQL Ser...more >>

SQL 2005 Active/Active Cluster don't listenig to 1433
Posted by Pat Coon at 3/20/2006 12:00:00 AM
Hello I have set up a new sql 2005 Cluster on a w2k3 box. Now I want to have a Actve Avtive configuration for my cluster boxes. If I try to do this with the config tool I want to set up both nodes to lisenig at the tcp port 1433. If I config it like this the sql server don't start any...more >>

Active/Active SQL Clustering Question.
Posted by Morgan at 3/18/2006 4:22:50 PM
Hello to everyone, Because im little confused with the number of instances in an active/active sql cluster scheme ,can anyone please explain me the right procedure? For example in a cluster with 2 nodes of Advanced Server i have the below : node 1 : SrvClus1\SQLInstance1 ...more >>

SQL cluster 2005 - Two disk but only one can be seen
Posted by WhiteJul at 3/17/2006 6:59:27 AM
I have a Windows 2003/SQL 2005 active/passive cluster. I have two share = drives which are part of the same cluster group. My plan was to place = the data and log files in the first drive and backups on the second = drive. However, I cannot see the second drive from SQL Management = Studio. Thr...more >>

StartUp Options File for x64 SQL Cluster
Posted by JT at 3/16/2006 10:57:26 PM
Hi all, I am setting up a 2 instance SQL 2K (32-bit with SP4) cluster on a 2 node Win2003 x64 ENT cluster. Each node has 4 x 3.0 XEONs with 8MB L3 cache and 16 GB RAM. I am looking for info on any switch settings I should use in the startup file for the servers to take advantage of the hard...more >>

Cluster resource could not be found.
Posted by Burley at 3/16/2006 7:50:30 AM
After a reboot of one of my node I am currently receiving the following message: The disk associated with the cluster disk resource 'Disk T:' could not be found. The expected signature of the disk was XXXXXXX. If the disk was removed from the server cluster, the resource should be deleted...more >>

Node Eviction
Posted by JT at 3/16/2006 5:46:19 AM
HI, I need to evict one node from a two node, two instance SQL Cluster. Beyond failing over all resources and ownership to the surviving cluster node, is there any other configuration change I need to make in SQL server before doing this? Thanks. -- John...more >>



Do I need Enterprise to do clustering?
Posted by Sandy Proesch at 3/15/2006 11:51:36 AM
I'm confused. Reading the SQL 2000 Resource Kit, it definitely says I need Enterprise in order to do failover clustering. But reading the product guide on the 2005 version says Standard has clustering capabilities. Is this something new to 2005 or is it a different type of clustering? We'r...more >>

Setup.exe does not launch when installing SQL 2000 on cluster
Posted by ketania NO[at]SPAM gmail.com at 3/15/2006 8:35:21 AM
I had SQL 2005 installed on Virtual node on Cluster on IA64 and then uninstalled it. Now I am trying to install SQL 2000 on Virtual node and setup.exe does not launch. When I double click the curse turns into a hour glass and then go back to cursor. It does not do anything. I can run MSI file...more >>

Physical Disk counter does not show up in cluster
Posted by Admiral at 3/15/2006 6:47:57 AM
The Physical Disk and Logical Counters do not show up in the cluster or node performance counters. I have verified that DiskPerf is supposed to install the counters at bootup (diskperf -y), but they do not show up in the Performance Monitor. For the record, I have only applied this to the ...more >>

SQL Server 2005 cluster
Posted by Rachell at 3/15/2006 6:27:28 AM
I have two set of SQL Server 2005 cluster servers(active and passive), every time open SQL Server management studio, there will generate error on event view(any client PC or sevrer itself) Event filter with query "select * from __InstanceModificationEvent within 10 where TargetInstance isa...more >>


DevelopmentNow Blog