Assuming we have 2 NIC Cards and one port on each of the NIC is NIC teamed for redundancy, do we use the other port on the NIC for the private network ? Or do we have to bring in a 3rd NIC to set it up ? What would be recommended ? Also when we have multiple clusters set up , can we share t...more >>

Well the subject pretty much covers it, We have a Single node cluster running SQL 2000 on windows 2003 Server, having completed the construction of our second datacentre, we now need to add a second node to it. Unfortunately the suppliers who set up the original cluster are long gone, and have...more >>

I am trying to install a named instance of SQL Server 2000 on an Active/Passive 2-node cluster on Windows 2003 Server. The installation proceeds until near the end, then I get the message: "The cluster resource failed to come online." When I click OK, a message appears saying I should instal...more >>

I want to set up a 4 node cluster where 3 nodes are active and 1 is the passive node that would take over in case any one of those 3 active nodes fail. How can I set this up ? Any documentation.. Using SQL 2005.. ...more >>

I am a little confused on the term "SQL instances" because I found conflicting documentation on the subject. The question is, can I install 4 "instances" of SQL 2005 as "default" instances on a cluster in different resource groups each one having its own unique IP, "virtual sql name" and ph...more >>

Hi, We have 2 node sql failover cluster configuration ( Server 2003 +SP2, MSSQL2000 ) We can succesfully query the data from other MSSQL Server over a linked Server. But, When we want to start a transaction to same server we are getting this message : -----------------------------------...more >>

I am having difficulty setting up my disks on my SQL 2005 cluster. I have a data disk and log disk for each instance (3) but when trying to setup a new DB, when I try to choose the log drive it does not appear. I remember choosing a location during setup for data files and this is what i...more >>

SQL 2005 AS installed on a Cluster. We are using a named instance and only one currently exists. MS White paper reads: The default instance listens on port 2383, while named instances are dynamically allocated. This behavior can be changed by explicitly assigning a port to either the defaul...more >>

Hello Everyone, I read the useful tips about proper cluster shutdown orders. We just set up a 2 node single instance (active/passive) Win2003 / SQL 2005 cluster. Unfortunately our customer asks for a script or batch to shutdown the cluster nodes in a clean way for maintenance purposes. Wit...more >>

Hi, I am trying to install SQL2005 onto a failover cluster. the latest install produced the following log file extract - Property(S): HeadText_ReadyInstall = Ready to Install the Program Property(S): HeadText_ReadyRepair = Ready to Repair the Program Property(S): HeadText_ReadyModify = ...more >>

I'd like to know how SQL Server 2005 handles identity columns in a database hosted in a clustered environment. I have concerns that there may be a chance that concurrent requests could result in one or more of the servers in the cluster attempting to insert a new rows for different requests wi...more >>

Using Windows clustering requires too long a failover time for my company's uptime requirements. While SQL 2005's mirroring decreases the failover time, it also only allows me to mirror to one server, thus putting me in a rough spot for DR. Is there any Oracle RAC type equivalent functiona...more >>

I'm installing a cluster with sql 2000 and the partition for the binaries is a clustered resource but SQL Server won't let me install the files there... Is this correct?? If so, how does SQL put the data files on the second node? sql 2000 win 2k3 ent/ edition -- ...more >>

Hi all, I'm having problem to update my SQL cluster with SQL server 2005 SP2. Here is the summary log: Time: 04/13/2007 18:47:03.120 KB Number: KB921896 Machine: FRESHCLUSTSQL01 OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 2 (Build 3790) Package Lang...more >>

Hi, Our production database set on cluster SQL Server 2005 (SP1). I installed client tools for all 4 nodes. Every node should show Microsoft SQL Server 2005 and Microsoft Visual Studio 2005 after click All Programs, but in one node the Microsoft SQL Server 2005 disappeared. While I go to Ad...more >>

Hi all, Here is my problem: I've having trouble to make my second logical drive available for database under SQL server 2005 (Other words: I cannot move database to my second database drive because I cannot see it in SQL server 2005) Config: - Cluster Acitve/passive - 2 nodes (Win 200...more >>

I am running a large mission critical application on a cluster. This is a 2003 server latest SP with SQL 2000 Enterprise latest SP also. This app has run for years with little change. Today at around 3:00 all connections stopped coming in. After some debugging, we found that we could ...more >>

Currently we have an ACTIVE/ACTIVE SQL Server 2000 cluster in our production environment. The current configuration is such that each node has a dedicated server hardware. Lets call one of the ACTIVE nodes as NODE1 and the other ACTIVE node as NODE2. We are in the planning stages of a SQL Serv...more >>

Hi, Imagine that my server has 4GB physical memory. I have added /3GB switch to boot.ini. Should I enable AWE configuration for my SQL Server to use 3 GB address space? Or AWE must only be used when I have more than 4GB memory? Thanks in advance, Leila ...more >>

When I try to backup a SQL 2000 database I recieve the following error in the output log. Any ideas? Thank you. SQL 2000 w/ SP4 [39] Database SolRounder: Database Backup... Destination: [G:\Backups\SolRounder\SolRounder_db_200704131221.BAK] [Microsoft SQL-DMO (ODBC SQLState: 42000)] Erro...more >>

I installed the windows cluster and a one node failover sql cluster, and both runs without problem. When I try to install the second node in the sql cluster the installation will be interrupted. In the event viewer i see following message "the cluster resource monitor could not load the...more >>

hi, I've setup database mirroring in high safety mode with automatic failover (with a witness) and the databases seem to be synchronising ok (I've failed over a few times to test and all seems well). The only problem I have however is that when I open up the Database Mirroring Monitor on one o...more >>

I'm unable to add a Second node (Win2k3 SP1) to a currently existing SQL2005 Cluster .I'm using the Add/Remove Programs and I'm trying to add it back in as another possible SQL Server owner . If I select "change" with Add/Remove (on good node)it only gives me options to modify my existing in...more >>

I want to remove a node from my SQL Server Cluster using Add/Remove Programs. the SQL resource is on the node that is remaining. Question: When I do the actual removal of the node, will SQL stay on line on the other node, or does it go offline for a short period of time? Thanks! ...more >>

As part of testing a cluster-to-cluster migration process, I am attempting to restore the master database from an old test cluster into a new one. I've read quite a bit about this online, and it looks like a relatively easy procedure. These are the steps I'm following: 1. Stop the SQL Serve...more >>

This is not my expertise, so would appreciate some help. Is it possible to create an active/passive failover setup or database mirroring without a shared disk? Client has two sql servers that they wanted to upgrade SQL 2000 to SQL 2005 and then use the second box for an active/passive co...more >>

Hi, I was applying SP2 to our single-node cluster SQL server (x64). All related locked processes has been stoped, except resrcmon.exe which is part of clussvc.exe. Should I menually stop 4 resrcmon.exe in the task Manager and apply SP2 or is there any suggestions? Please advise. Than...more >>

Is Mgmt. Studio part of a clustered resource, say the DB Engine ? On a two node active-passive Win Enterprise Server 2003 / SQL Standard 2005 cluster, when node 1 is active, I can get to Mgmt. Studio on the virtual resource (RDP). When node 2 is active, I cannot. But I can connect remotely ...more >>

Hi We have one server runs all our databases and websites and we have just bought an identical server to mirror all files and databases if there is a problem we will switch the firewall rules to bring the second server online. What is the best way to update SQL Server 2005 on the backup ser...more >>

hi! our AD, say company.com, has clients with different DNS suffixes. E.g. dc1.company.com dc1.company.com sql1.sub.company.com sql2.sub.company.com DNS-Settings are correct, dNSName-Attribute in AD is correct, too. All Servers are member of the Domain COMPANY.COM. when joining the domai...more >>

Here's my question. I'm new to SQL and clustering but I'm on my way to having my cluster set up on two W2K3 64 bit servers. Everything is patched up and ready for my installs. One server will have SQL 2K and SQL 2K5 on the other. My question is this: I have a HP storage array set as my sh...more >>

Hi, I'm trying to install sql server 2000 on windows 2003 SP1 and getting below error message. 14:22:57 End Action : Run setup on cluster nodes 14:22:57 SetClusterSecuritySQL (TESTAD01\SQLSRV) and (TESTAD01\SQLSRV) returned: 0 14:22:57 Begin Action : CreateVirtualServerResources 14:23:12 En...more >>

I'm not completly sure how to phrase this question. In the 2 node cluster I'm working with, I noticed that there is a database named "Utility" on both nodes of the cluster, which confuses me. I thought an instance was clustered, not a database, so finding the duplicate DB doesn't make sense...more >>

I am new to clustering and would like to implement and active/active SQL cluster, which would allow the functions of one of the nodes to fail over to the other in the event of a problem. I have two identrical servers in terms of hardware connected to a SAN and running Windows Server 200...more >>

We are planning on using Database Mirroring internally within the data center for HA and since its used, I am left now with log shipping or possibly some SAN replication. I think either one will work with log shipping being very affordable.. Free !!! Does anyone see any pros to SAN repli...more >>

Hi, I am also kind of new to clusteirng and there are some questons I have regarding how to best setup storage in a clustered environment: 1. My client is planning to setup a 1+1 clustered environment attached to a Hitachi AMS1000 SAN. We need to plan how to properly allocate around 4TB of...more >>

I just started at a new company and am looking at their active/active cluster and immediatly saw that the CPU usage between the machines is very different. When I asked why, they said the DB1 is on node 1 and DB2 is on node 2. Duh. What am I missing? I thought an active/active cluster woul...more >>

I was trying to take a quick back of a db and wanted to restrict access for a short time and set it to single user access. Now I am wantting to change it back but the gui is not allowing my to do so. What is quickest way to change it back? ...more >>