I know there is the heartbeat that checks for ping... But i also believe there is a sql related check too ..right ? I guess what im getting at is ..if the server is super busy that this sql related check cannot even get a thread to connect, will the cluster fail ? Thanks ...more >>

Currently we use Log shipping between our active site and our DR site. The question I have is when we do DR testing at the DR site to test recoverability, we have to recover all those Log shipped databases which means we are exposed until our DR tests are completed. How does one go about en...more >>

Our organization has a medical application that is dependent on 6 independent SQL databases that are loaded on 1 SQL 2005 server/instance. Can a "SQL 2005 High Availability Database Mirror" be used to mirror all six databases and automatically failover. If I have understood correctly, SQL 200...more >>

Hi, I was trying to find information on the OS and SQL requirement for SQL 2005 cluster. Can SQL 2005 cluster run on Windows 2003 32 bit standard edition SP1 running SQL 2005 SP1 32 bit standard edition? Thank you....more >>

Hi guys, I have to set up a new SQL 2005 instance for my company this weekend and I have no experience working with SQL clusters. Can someone help me with the detailed steps of what will be required and involved in setting up the new instance? -Which server do I install too? both boxes?...more >>

Have any of you ever run across a problem in SQL Server 2005 running an active/passive cluster on Windows 2003 SP1 Enterprise, where you can connect to the server via Management Studio open tables, see dbs, open properties. Everything runs fine with the exception of being able to run queries a...more >>

Where can i find enhancements made to SQL 2008 clustering ? I heard that we could now run SQL patches without taking the entire cluster offline as part of the new feature. Is that true ? If so, where can i read more ? ...more >>

Is there a document describing how to setup a multi-instance SQL 2000 Enterprise Cluster in a single instance failover environment on Windows 2003 R2 Enterprise? ...more >>

Hi there I'm having difficulty rebuilding the master database with a new collation. I'm running the following from a command line: C:\>start /wait c:\SQL_Server_2005_x64\Servers\setup.exe /qb VS=SDBAHSQLPC01 INSTANCENAME=SDBAHSQLPV01 GROUP="SQL Group" ADDNODE="SDBAHSQLPN01,SDBAHSQLPN02" ...more >>

I'd like to poll everyone out there to see what the approach is with regard to clustering, two nodes. Do you prefer active/passive or active/active, and why? TIA Michael MacGregor Database Architect ...more >>

SQL Server Std Edition SP2 on windows 2003 EE R2 SP2 AWE enabled 8 GB of RAM SAN attached 1 LUN Min server memory @ 0 max server memory @ 6656 So using perfmon page life expectancy shows 0 and stays at 0 buffer cache hit swings betweeen 90 - 99 Checkpoint pages/sec = Avg 0 Lazy writes/sec. ...more >>

For some reason when i try to install a failover cluster SQL2005 Std. on WIN 2003 ENT I am getting the error "The Virtual Server name you provided is not valid. To proceed, provide a virtual server name. For more information, see Instance Name, in SQL Server Books Online." Does any one hav...more >>

Hi, We are having difficulty uninstalling a named instance from our 2-node, active-active cluster. When we try using the CD setup program, none of the instances appear in the drop down to select which instance to remove. I have heard that there is a 'manual' method to do this uninstall bu...more >>

Dear gurus, i need help!! i want to setup a clustering environment using two nodes and connected to a storage. scenario: i've setup both node with Windows 2003 R2 EE SP1 and installed with SQL Server 2005 EE. i've setup both server as an AD with same domain controller name but with differe...more >>

We are using SQL Server 2000 SP3 on Windows 2000 Advanced Server 2000 SP3. Hardware is a cluster with two servers: Compaq Proliant DL580 with external storage device Compaq MSL 1000(Raid 5). Since last week we encountered server become very slow on and off (about 5 times) and manually swi...more >>

Thanks in advance for any assistance. We moved from a single-server instance to Active/Passive cluster and we are experiencing a higher CPU utilization than we saw on the single server. Is there any reason why the CPU utilization would increase just by moving to a cluster? Thanks, Morg...more >>

In a cluster environment for SQL what is the best way to find out the name of the real physical computer? I know the SQL instances are virtual and the but I want to find out what real server is it running on. Is there a way to find out via EM or via T-SQL? I am sure others have run into this too...more >>

Hi. Wonder if anyone can offer me some advice? I'm currently involved in setting up some new kit prior to an upgrade of SQL Server 2000 Standard on a single Win 2000 server to SQL Server 2005 Standard x64 on a single node Failover Cluster. Additionally databases are to be held on FAS storag...more >>

Hello there I need to create an environment for failover clustering and I have an existing hardware Does microsoft offers some special hardware for failover clustering? ...more >>

Simple sql cluster - 2 machines active\passive I see that any sql activity is written to both logs (logins, backups, etc) to both servers. They have the same time stamps. I would of thought that it only writes to only the event logs for the active server. It looks like both machines are act...more >>

For testing purposes is it possible to mirror databases on different OS? The version of SQL is the same. I thought I remembered reading something about the differences in encrption technology??? ...more >>

One node of a two node cluster failed yesterday. The second node came active but when it tried to create the shares it failed with event ID 1068 "failed to start with error 2116" and "failed to start with error 87" I cannot find these error codes. Any help will be appreciated...more >>

Hello, I have a Physical/Virtual node MSCS failover cluster. I am running 64bit SQL 2005 and Windows 2003. I have read enough posts that indicate you in 64 bit SQL Server you should set the max memory. Unfortunately my physical box has 32 GB of memory (I could utilize all of it!) and my ...more >>

We have a W2K3 EE cluster with 1 SQL Server 2005 instance on each. Currently we have 4GB of memory each with the default settings. We are getting new memory to take each server up to 16GB. I want to set my min/max server memory to 7.5GB so we can failover successfully and not use any OS m...more >>

Hi, We have sql server 2000 and 2005 on one server (windows 2003 server). Is it possible to cluster both instances with another server? Are there any special considerations for this situation? Thanks in advance, Leila ...more >>

Hi, I have a cluster with one right working Node, and I want to add second Node to existing structure. Every stores (disks, cluster name and IP, SQL IP, SQL network name) except SQL moves between nodes succesfully. Installation of SQL 2K SP2 at Virtual Server proceed correctly, but I can't up...more >>

Both 2 nodes run on Win2003 Enterprise. What IIS version ought to be installed? 6.0 or 7.0 beta? ...more >>

Hi everyone, As the subject indicates, I am very new to Failover Clustering. Nevertheless, I need to get this up and running for the organization. I suppose it's a 2-node cluster that I will be configuring. The first being the principal server and the second being the failover cluster. I...more >>

I'm setting it up using the directions provided by Microsoft @ http://msdn2.microsoft.com/en-us/library/ms189047.aspx The problem I originally ran into was exactly like the one mentioned in the following posting: http://www.microsoft.com/technet/community/newsgroups/managed/dgbrowser/en-us...more >>

Hi, I have a SQL server that has started to get fairly busy, to the point where our web application customers are saying their app is running too slow to be usable. I was wondering if I could have some tips as to wether it would be better for me to cluster, or to add other , seperate servers...more >>

Hi Guys, I'm trying to configure mirroring among 3 servers, principal,mirror,witness, i was able to configure it successfully but when i start mirroring it gives this error the server network address "TCP://xx.yy.zz.com:5022" can not be reached or doesn't exist. check the network address na...more >>

Hi OK, so we have had our SQL 2K5 Active/Passive cluster in place for a while now and things are gradually slowing down. I need to start thinking about what to do next to maintain a satisfactory level of performance. (In terms of upsizing versus archiving, further optimisation, tuning etc...more >>

I am trying to enable AWE memory utilization on my two node cluster. I have made the policy changes to the LOCK PAGES IN MEMORY option. I know this change is going to require a reboot. Can i just run a normal reboot failure to the backup node. Wait for the Main node to comeback online then re...more >>

Hi guys, Please let me know why we need to assign IP address to SQL Server cluster(Virtual server) while setting up SQL Server on a windows cluster? Why cant we do everything with virtual server name(as ultimately the name is going to float between the available nodes)? If we can connect t...more >>

Hi All, Are they're any Best Practices with reference to installing a 2nd instance of SQL 2K5 on an Active / Passive cluster running under Win 2K3? TIA, Bobby ...more >>

Hi all, One of our customers have what looks like a MS DTC related problem on a SQL 2005 cluster. Setup: Web server in DMZ running Windows Server 2003 R2 Standard x64 SP2 2 node cluster in PZ, running Windows Server 2003 R2 Enterprise x64 SP2 and SQL Server 2005 Standard SP2 Problem...more >>

I currently have a 2 Node Failover SQL 2000 cluster running on 2 Windows 2003 servers. I need to upgrade this to a SQL 2005 cluster. I will be keeping the same hardware, same IP addresses, same cluster name etc. Is this a fairly simple process? Do I just put the SQL 2005 enterprise CD in...more >>

All, Could you guys please recommend some good IBM machines as i dont have a choice (No HP's or Dell's) for running SQL Server as a cluster (Active/Active with 2 Nodes) with 32GB memory using Intel's 32bit architecture or IA64 . I am working on a consolidation project and trying to put t...more >>

When I open CLuster Administrator and type in the name of my SQL CLuster say "Cluster1", and right at the top when it opens in the title it says FGS(Cluster1) and then the tree drops down with FGS as the root. So what is FGS ? Is that the name of the Windows Cluster ? ...more >>

If i have the name of a node, how can i find out what Cluster is active on it or if I have a SQL CLusterName, how can i find the underlying node names ? Is there a SQL that can find this ? ...more >>

If i want to have 2 instances on a 2 or 3 node cluster, what would these cluster names look like ? Would they be in the form of Inst1 and Inst2 or Cluster/Inst1 and Cluster/Inst2 ? ...more >>

I'm not too familiar with clustering SQL, but I was wondering if the following would be possible. If we have an A/A/P cluster, if it's possible to have one virtual server run SQL Server 2005 and the other run SQL Server 2000. We have an application that still doesn't support SQL 2005, and ...more >>