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 > february 2007 > threads for february 22 - 28, 2007

Filter by week: 1 2 3 4

sql 2005 active/active cluster
Posted by andyz at 2/28/2007 7:16:08 PM
I have a consultant telling me that there is no such thing as an active/active sql cluster. I want to install 2 seperate instances on 2 seperate sql 2005 servers in a cluster. The consultant is telling me that this is active passive because only 1 instance is active at a time on 1 server. ...more >>

Cannot delete Maintenance Plan job
Posted by Yuhong at 2/28/2007 1:59:49 PM
Hi I had a Maintenance Plan with a scheduled job setup in SQL 2005. I have deleted the Plan without deleting the scheduled job. Now I cannot delete the job without the Plan. Any help will be great appreciated....more >>

SQL 2000 extra instance into same group
Posted by Jason at 2/27/2007 5:45:03 PM
I would like to add 2 instances of SQL 2000 into one Disk group within the cluster IE I have InstanceOne utilisng setup in cluster group using a drive (O:\) and would like to install InstanceTwo into the same cluster group using the same drive (0:\) When you go through the installation...more >>

how to setup Integration Services on SQL 2005 cluster
Posted by denise at 2/27/2007 1:25:49 PM
We have SQL Server 2005 cluster setup, active/passive, 2 nodes, on Windows 2003. If I try to add a maintenance task using sql management studio on my pc I get error: "apply to target server failed for job". If I try it using management studio while on the active node of the cluster I get err...more >>

Alternative to IPSec?
Posted by RL Coppedge at 2/27/2007 9:22:11 AM
The client I'm working with has a 2-node Failover cluster. Owing to their environment, they have several machines accessing the many databases. For cost reasons, they went with SQL standard. As to securing the traffic. I understand that IPSec isn't supported for failover cluster, owing t...more >>

Servers with SQL and Application Installs
Posted by Woo at 2/27/2007 3:54:11 AM
Hiya, We have several servers that have SQL Server and an application installed, therefore they are not just dedicated to SQL. Some of these applications have services, other have exe's that are launched by users over the network. We are looking at high availability options for these serv...more >>

SQL 2005 Cluster w/Mirroring
Posted by Shawn P Bolan at 2/26/2007 6:47:53 PM
I have a SQL 2005 cluster running, now the client would like to have the dataset replicated to another SQL server offsite for further redundancy. For the time being, the offsite server will be a stand-alone, however in the future it could become another clustered solution. The network conne...more >>

Changing sql service account group memberships on 2k5 cluster
Posted by Brian K at 2/26/2007 3:17:35 PM
I am administering a 2005 SQL active/passive cluster. The sql services are all running under a domain logon that has "Domain Admin" rights, and I'd like to change that. According to http://support.microsoft.com/kb/915846/en-us, it seems that doing so might necessitate re-installing the ent...more >>



error trying to start new maintenenace plan
Posted by steve at 2/25/2007 11:21:00 PM
Hi , I am new to sql 2005 and clustering I too have made the same mistake as wayne see Geoff response on the 5th of Feb. I have a 2 node cluster and I have installed SQL within the cluster. I just need clafication that I only need to run the setup and just select integration services no o...more >>

Increasing Max Memory on second node of failover clusterring
Posted by turky at 2/24/2007 11:31:10 AM
I have SQL 2005 failover Clusterring on windows 2000 adv. server with physical memory 8 GB , i can increase the max memory to 6000 MB in the first node but when i move cluster to second node i can not increase the max memory to more than 2100 MB , i want to the second to be online with max mem...more >>

connection to cluster admin
Posted by Wayne at 2/23/2007 3:16:27 PM
I was trying to move the msdtc resource to the msdtc group and I have messed up the cluster by taking too much offline in an attempt to move it. now I don't have access to the cluster as the cluster ip, network name are offline. Can I tweak the registry somehow to regain access to it? Stupid...more >>

Rename virtual SQL Server in cluster
Posted by at 2/23/2007 1:57:15 PM
Can I rename my virtual cluster name that has SQL 2005 installed after I build it for example if the virtual name is MASTER_New to MASTER? thanks, ...more >>

DTC in multiple instance cluster
Posted by Bjørn at 2/22/2007 1:53:48 PM
WE have a 2 node win 2k3 x64 cluster (also x86 clusters with same problem) with 2 instanses of SQL 2005 x64 and the MSDTC resource in the admin. cluster group (quorum group). This is a active/passive cluster, all 3 groups/vir. servers on same node. The problem appears when one of the SQL se...more >>

Active/Active Cluster Encryption
Posted by Steve at 2/22/2007 11:05:18 AM
Can anyone give me some tips on enabling encryption on an active/active cluster? the particulars as I understand them: 1. Encryption is enabled on each node, and 2. Each nodes encryption is based on a certificate from Certificate services 3. Certificate services that must be installed on...more >>

Doc for SQL 2000 Cluster
Posted by Hemang at 2/22/2007 8:29:24 AM
Hello Is there any brief howto to configure SQL 2000 Cluster on a VM? Thanks ...more >>

Doc to setup a SQL 2000 Cluster?
Posted by Hemang at 2/22/2007 8:24:54 AM
Hello Is there any published document to setup a SQL 2000 cluster for demo on VMs? Thanks ...more >>


DevelopmentNow Blog