I have a three node cluster with three virtual sql server 2005 installed. Now I want to take one node out of cluster to make a two node cluster. According to the post of Daniel ("evicting a node") and other reading, we have to run the setup again. My question are: 1. do I have to run the setu...more >>

Hi Experts, I have a customer running SQL Server 2005 and his database's are on the physical server. We would like his entire database only on the SAN and not on the server. Can anyone tell me what are the best practices to place this on a SAN. Shall we do a Mirroring on SAN and can we o...more >>

Hello there Here is question i got: I have sql server 2005 failover clustering. On node1 someone has run procedure which update data on huge table which take over 8 hours. In this case I can't release the database (as far as i know) because if i will kill the process it will rollback all ...more >>

Helo, i install and configure database mirroring in SQL 2005 with automatic failover. Client aplications use ADO.NET or the native SQL Server client driver to connect to database. I know i have to write next connection string: "Data Source=ServerA;Failover Partner=ServerB;Initial Catalog=Adv...more >>

Hi, Can someone give me an opinion with installing SQL Server 2005 with clustering and use those servers for file servers at the same time. Thanks Jacques ...more >>

How can we convert our SQL Server 2000 (Windows Server 2003 R2) Active\Passive cluster to Active\Active? Thank you. -- Mike...more >>

I have sql 2005 installed with sp2. I have an external file server with 1 terribyte of space. I want to have my data and log files on the external file server. I mounted and mapped the external server at S:\Data and T:\Logs. However when I try to create a db it only lets me use the local C: or...more >>

Hi, Can we use Majority Node Set to run SQL Clustering. If yes, Can anyone provide me the step by step guide to do this. Thanks Neeraj Mehra...more >>

We have a 2 Node SQL Cluster that I was trying to upgrade to win2k3 from win2k. In the process the cluster got completely corrupted. I followed some documentation online and did: Cluster Node <name> /ForceCleanup Now I don't even see HKLM/Cluster When I try to import 'HKLM/Cluster' from ...more >>

Hi, I am in the process of upgrading our servers from win2k to win2k3 SP2. We have a 2 node failover cluster services confg for sql2k. So while upgrading one of the two nodes in the cluster, I ended up evicting the node that was being upgraded. Now that I have the successfully upgraded the se...more >>

....has anybody tried this? ... I need to install the 10g client on a cluster virtual server so that I can use integration services to pull data from oracle to sql. I have this already running on non clustered servers. Question is, is the 10g client Windows cluster aware? Any advice would...more >>

Hi! I have two Windows Server 2003 Enterprise servers configured to an basic cluster. I want to install SQL 2005 on this servers to get high avaiability for the databases. Unfortunately i can't find any Step-By-Step guide about installing SQL to use in an cluster environment. Does somebo...more >>

Hi all, I perfectly well understand how to create a SQL 2005 cluster. So I have a 2 node Cluster Active/Passive, on which i have SQL 2005 installed, with a quorum disk. Everything's fine. Now, i have several others servers to install (Exchange, Moss, OCS), each servers need an instance in S...more >>

I am looking at putting the specs together for a new SQL Server 2005 cluster, two nodes. It needs to be capable of supporting multiple customer databases, around 20-30, average database size is 3GB but several will be in the region of 10-20GB, capable of handling 10,000 transactions per minute...more >>

what is the best way to store passwords and credit card information in SQL Server 2005? ...more >>

We have updated multiple instances of sql server 2k5 EE to SP1 and oddly enough some of them still show that they are at RTM version 9.00.1399.06 instead of 9.00.2156.00. when checking through ssms and select @@version When we run SP1 against it to see the instances it recommends for an updat...more >>

I currently have active/passive SQL 2005 STD SP2 servers. I have found some differences between the settings when I failover between both SQL servers. I think that one of the DBA's made setting changes as well as created maintenance plans while logged into the specific server (SQL1) instead ...more >>

Our failover SQL cluster is a two-node single instance environment - SQL 2000 Enterprise SP4 on Windows Server 2003 Enterprise. We're currently using NIC teaming to give us some hardware redundancy since the blade has two Broadcom NICs on it: one for the hearbeat private network and the other...more >>

I'm trying to register the server in Management Studio and I can't connect to the 2nd instance on the cluster. I'm using the virtual IP of the instance and even throwing in the instance name. Tried: VIP Instance 1 = 10.200.5.30 <- Works for first instance, registers. VIP Instance 2 =...more >>

We had a system that ran very well as an individual server. With a need to ensure uptime, though, we moved to an active-passive clustering solution. Now, we've noticed that the SQL Server instance running on the cluster is slower than the old, single server. How could this be? None of the qu...more >>

Quick question. Running Windows 2003 Enterprise SP1 and SQL Server 2000 Enterprise Sp4+. Using clustering, I have my SAN drives for the Data and log and those transfer just fine. However, on each NODE, i have another 240GB that I want to use for temp backups and restores. Yet, due to the...more >>

Hi, I seem to be at loggerheards with a member of our TA community. We have a 2 node cluster that doesn't have exact hardware. I've quoted the MS stance (see below) but he seems adament it's not an issue. Both servers will form a 2 node SQL cluster, both same spec but the 2nd node has ext...more >>

I am testing an active/passive cluster running W2003 and SQL 2005 SP2. What I try to test is: Power down one node and then on the active node using Add/Remove program to attempt to take that node out. According to what I read from the Web and a book, this is a required step regardless the acce...more >>

In a nutshell, all I want to know is: On an active/passive cluster (2003 enterprise) Should I install one SQL 2000 enterprise as a virtual and the 2nd as an Instance, or can I install both as Virtuals? (Each having it's own name and IP on the same active node?) ...more >>

Hello, I explain, I will have a 3 nodes cluster, all nodes will host 1 instance, but I need that 2 of them get the same instance name. during the setup it refuse, I don't understand why as each instance will have it's own virtual server and the path will be different SERVERA\INS1 and SERVER...more >>

Hi, I have a question concerning clustering SQL 2005. Let's say that you installed SQL Server 2005 on a machine with no clustering and you want to enable clustering do you have to reinstalled SQL server completely? Thanks Jacques ...more >>

We have a two-node active/active sql cluster (sql 2005 and windows 2003 EE 64bit), and we configured MSDTC in one resource group running on one node. It seems that only the SQL instance that is running on the same node which MSDTC is running can use distributed transactions. Is there any way t...more >>

I have two nodes (active/passive) in my cluster that I am trying to upgrade from 64-bit SQL 2005 SP1 to SP2. I followed Microsoft's instructions and logged into the active node with Admin Privleages. However, the setup keeps failing when attempting to upgrade the Database Services. It says:...more >>

Hello, If I change cluster failover/failback settings will that affect any current running services? Specifically I want to change the resource setting to "Do not Restart". If I change that will it affect the currently running SQL services? I don't want to initiate the restart of any pro...more >>

Hi I have WSUS v.2.0 in a windows 2000 server with msde and I want to know if it is possible to migrate only the database of WSUS from MSDE to a server with windows 2003/sql server 2000 or 2005 depending if exists any kind of incompability. Can someone help me on this issue and explain m...more >>

Hi, Just about to set up SQL 2005 cluster. Do I need to set up Windows cluster environment, then set up SQL 2005 cluster? Thank you...more >>

I have a few shares setup on my SQL 2005 Cluster and when a user tries to connect to a share I get an error message. Has anyone seen this I have changed the registry setting to 15 but I am still getting the error message. The KB225782 says this fix applies to NT 4.0 not Windows 2003. I am go...more >>

I have a 2 node SQL 2005 cluster. I have a few questions about the Quorum resources. When I setup the cluster I pointed the vitural server quorum resource to a local disk. (Q:\MSCS). I feel like I did not set this up correctly. The 4 Resources types I have in the First Resourece group is. ...more >>

We are currently planning for two-node SQL 2005 cluster for some of our applications. We are hearing that SQL 2005 cluster doesn't handle being patched with MS hotfixes well. It probably matters what kind of hotfix is being applied but does anybody know what is the best procedure/practice for...more >>

Microsoft said that not recommend that the Integration Services service be configured as a cluster resource. (http://msdn2.microsoft.com/en-us/library/ms345193.aspx) What is the recomended configuration to have Integration Services in a high availability environment? Thanks....more >>

The MS Cluster install went well, the SQL 2005 went great as well. No errors at all...that was until I tried to install SP1 then tried installing SP2. I get the same error every time. It has to do with a recent install of KB 921896. The error on the summary.txt file is 28017. I though may...more >>

Hello, I have seen various posts on how to move SQL databases files on an existing SAN to a new SAN. Geoff, Rod, Russ and others have provided valuable suggestions. I need help clarifying something -- although the files can be moved by following some steps very carefully, do the SQL instanc...more >>

I have an existing Acitve/Active SQL2000 Cluster on Win 2003R2, and would like to add an additional node to the cluster. I dont initially wish it to be an active node. How do I an a node in this scenario? I am of the impression the only way to kick of an install involves adding another virt...more >>

I am new to MS SQL and would like to break a SQL Server 2000 cluster and leave the database in tact. I have 2 HP DL380's with an HP StorageWorks SAS device. I need to use one of the servers and the SAS device for High Availability with VMWare. Can some one tell me what is the easiest way to do th...more >>

I know there is a public network for all application communication and one for hearbeat . Are there any more ? Does one connect the hearbeat network to like a local hub for the nodes or to the same public network ( dont know if im stating this right) ? Whats best practise to set up the priv...more >>

I have 2 new servers I want to setup for clustering of SQL 2005 Enterprise Edition. Do I setup a Windows Cluster and setup SQL 2005 on both servers? Do I setup Windows then setup the Clustering within SQL 2005? Or both? Thank you for your assistance....more >>

I've added another cluster resource drive to the group and sql 2000 instance is in. Sadly, the instance is not recognizing the drive, which is making it pretty hard to create backup devices on the new drive. which is why i added the new drive. Is there some trick to this that i'm missing, or is ...more >>

Can additional nodes be safely added to the cluster without taking the entire cluster offline ? So for instance, if we have a 2 node single cluster today, can i add 2 more nodes to make it a 4 node 3 instance cluster without taking the current 2 node cluster offline while doing so ? ...more >>

How many active nodes can MSCS have per cluster ? ...more >>

I have a SQL 2000 SP3a server running clustered on Windows 2003 Enterprise Edition SP1. We have a need to bring in a newer/faster Windows 2003 server, however in a non clustered environment. Can I /Should I install SQL 2000 SP3a on the new server (non clustered) and point it to the clustere...more >>