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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|