Where are the clustering logs ? Basically I am trying to find cluster errors or the last time when nodes failed over,etc. ...more >>

Quick question. After setting lock pages in memory. Should we set the min and max memory. Or Do nothing Or? Thanks for any info. ...more >>

I am in the process of implementing a SQL Server 2005 Database Cluster and have a question regarding the Quorum drive. Proposed Specs: 2 - Dell NX1950 "XEON Quad Core" mated to Dell MD3000 setup as such... 2 - 73GB 15K SCSI Drives = C: (Array: 1 for SQL Binaries & System) 9 - 73GB 15K SC...more >>

Hi All, I have a question, we have 2 node cluster Win2003 R2 Enterprise with SP2 , SQL Server virtual is installed on cluster. It is SQL2005 Enterprise x64 with SP2. MSDTC resource is created as cluster resource in cluster group on node1 and it is running, one SQL virtual server is insta...more >>

Pardon if this is not the correct forum but I have a requirement to install the Oracle client on a 2-node MS cluster used exclusively for SQL Server 2000 clustered instances. An application requires connectivity to external Oracle datasources. Is it technically feasible create perhaps a generi...more >>

Pardon if this is not the correct forum but I have a requirement to install the Oracle client on a 2-node MS cluster used exclusively for SQL Server 2000 clustered instances. An application requires connectivity to external Oracle datasources. Is it technically feasible create perhaps a generi...more >>

We have some sp transactions that take minutes to process and tend hog the cpu resources slowing other requests on a busy website. I have a few questions. 1. Can a specific cost be assinged to a stored procedure, so as to allow for the execution of the sp without maxing out the cpu? 2. ...more >>

We just migrated a large database from SQL 2000 ent ed. to SQL 2005 ent. ed. This migration included moving to larger, faster hardware on an active-passive clustered pair of Win 2003 servers (32 GB RAM, quad processors, etc). Once the migration & compatibility changes to the database were ...more >>

The nightmare has happened... The passive node of a 2-node Active/Passive SQL2K5 cluster had a critical drive failure and there is no recovery disk or backup to restore from. At this moment only the Active node is running (and running fine). I have a server with a clean OS install which I c...more >>

Say I am setting a 2 node cluster. One node is physically named ServerA and the other physically named ServerB. Now when i install MSCS, I take it we need to give it a cluster name right.. say we called it "ServerCluster". Now when we install SQL on top of it, is the SQL Clustername now "Serv...more >>

We have traditionally used a rolling upgrade method for moving to new hardware on a MS cluster. We would add one new node tp an existing 2 node cluster and install SQL Server to the new node. Once we get the new hardare all installed, we wpould uninstall SQL Server from the original nodes an...more >>

Hi, I had installed an SQL 2000 Cluster on one of the two nodes server that running Windows 2003 Ent version, but the other node server cannot join the SQL cluster and the setup process always jump out of the screen that need to input Admin username, password and domain name with no errors....more >>

First, Is it Necessary to create an MSDTC Group on your SQL Cluster with its own name, IP and resources or just a good idea, I am planning on doing it, My last SQL cluster did not have one But I didn't build it. I just want to be sure. Second, When you create a SQL Cluster and use the defau...more >>

I've inherited a Windows 2003/SQL Server 2005 active/passive cluster that has MSDTC clustered in the same group as Cluster Name, Cluster IP Address, and the quorum drive. It's not configured to be "network enabled." What steps do I need to take to fix this?...more >>

Hi, We are running clustered SQL 2000 SP4 on Win2003 SP1 with 4 instances (DB2,DB3,DB4 on the problem node) At the time of the events there was a large amount of processing being undertaken on instance DB03 On this occasion the server hung but didn't failover. It had to be manually fail...more >>

Hi, I am trying to test the clustering on our two new servers, but we don't have SQL 2005 std or enterprise CD yet. Can I use evaluation edition (downloaded from MS website) to create a test cluster? -- Brian ...more >>

Hi, ever since last week I have a doubt about a type of clustering implementation. Is it possible to cluster more than one SQL Server instance. I mean i know it is possible to cluster one instance... so that when that instance fails the other one enter into context be it either manually or autom...more >>

Hi there and thanks in advance, My ultimate goal is to get always-on redundancy for our ASP 2.0 session state service for our web farm. I'm exploring off-the-shelf products like ScaleOut and Ncache, but I wanted to try the recommeded Microsoft method of just putting the session state data into...more >>

How well does MS clustering meet the 99.999% availability? What other technoologies/architectures that do a better job from this stand-point? Gigel ...more >>

Is there any article where one can set up say a 4 node cluster with 2 or 3 instances? If I have a 4 node cluster with 2 instances and say instance 1 and 2 are tied to node 1 and node 2 respectively... is there any priority where we can specify that if node 1 fails, instance 1 will move to n...more >>

I am looking for some help with a SQL Upgrade that we are doing. We have an older server running SQL 2000. We also have a MSCS cluster that we've built which is running SQL 2005. We want to get all the databases on the SQL 2005 cluster and retire the SQL 2000 server. Is there any way t...more >>

Hi. I have installed an SQL 2005 Cluster on a Windows 2003 Two Node Active/Passive Cluster.Below is the brief of my Netowrk 1.I have two Active directory domain controllers running Windows 2003 R2 Standard edition with SP2. 2.i have installed a Windows 2003 Two Node Active Passive Cluster...more >>

Hi all.. hope someone can help me on this.. I'm a beginner and have limited knowledge on clustering. I managed to setup 2 set active/passive cluster with SQL clustering on 2 different site which is connected through lease line. Plant 1: Cluster IP : 192.168.128.150 SQL Cluster IP: 192.168....more >>

We have two Microsoft Windows 2000/SQL 2000 clusters that need to move from one SAN to another. The old SAN is going away. Does anyone know of a procedures or white papers on how to accomplish this. -- Dave...more >>

I had a hard time with my node replacement. And I am hoping to find out what I did wrong and perhaps some answers to a few lingering questions, I want to step through what I did 1. I was using a whole new name and IP address for the new node, so I place it on the network the day before and ...more >>

I have setup a couple of SQL Server 2 node clusters in the past and was always in a domain environment. I now have to setup a 2 node cluster in a none domain workgroup environment if anyone has any tips I would appreciate the advice. Thanks, Andrew...more >>

I would like to add another volume to my two node sql 2005 cluster. From what i have been reading i need to shut one of the cluster nodes, add the drive to the cluster then bring the backup node back on line. Am i missing anything??? Thanks for the help Noah Hamilton Sr Systems Administ...more >>

Windows 2003 N+1 cluster, SQL2005 enterprise + sp2 I have a N+1 cluster and installed default sql instance and one named instance. SQL Browser service is running on the node which owns the named instance; UDP port 1434 is opened on the firewall. I had problem connecting to the named insta...more >>

Hi, Can someone tell me if clustered SQL servers (2005) have to be part of the same domain? I can't find any docs on this. Thanks - Steve. ...more >>

I have a general Question, I am going to evict a node from My SQL cluster and replace it, Do I need to "evict" it from the SQL Cluster in any way, or can I just evict the node form the Windows Cluster and remove SQL or remove SQL first and then evict node -- Scott A Cummins Sr. Systems E...more >>

Hello, I have recently installed and configured SQL 2005 SE with database mirroring configured with high safety with automatic failover synchronous mode. My question is (I probably missed the principle idea) in case of failover occurred how do the clients redirect to the second node transpar...more >>

Hi, I have been looking for the last few hours for how to move a non-clustered environment to a clustered environment without having to change the connection strings of any of our applications. I'm not finding it anywhere. It's been a while since I did this, and I thought we could have a ...more >>

Hi, Is the "Cumulative update package2 for SQL2005 SP2" (http://support.microsoft.com/kb/936305) cluster aware? Or do it need to be installed on each cluster node? Thanks! SQL_help ...more >>

Hi All. I want to deploy an sql 2005 cluster on a Windows 2003 Active/Passive Cluster.Are there any KB articles avalible that will guide in deploying sql 2005 Cluster. Appreciate it. Regards -- Khalid...more >>