Has anyone seen that if you install SP4 on a SQL 2000 cluster that it will change the failover setting to affect the group regardless of its previous state? It doesn't do it for Full Text the first time you apply the SP but it will if you reapply the SP. It also sets the setting for "non-SQL" ...more >>

Hello, I currently have a SQL 2000 SP3 STD running in my org, I want to move it's contents to a clustered (two node) system running SQL 2005 STD edition. Is it possible to move the entire contents of my old SQL environment to the new environment? I would like to preserve user logins and t...more >>

The first pass at my SQL Server 2005 active/active install failed.. It appears to be complaining about the task scheduler on the other node, but it is running.. I found the following article: http://msdn2.microsoft.com/en-us/library/ms180849(SQL.90).aspx The service cannot be started,...more >>

Everyone, Could someone please recommen some good books for SQL clustering over Win2K3? Thank you. ...more >>

I have a two-node SQL Server 2000 cluster running on Windows 2003 SP1. I have two named instances running in active/passive mode. I have the cluster resources set up in 4 groups. The first group contains the cluster resources (cluster name, cluster ip, and the quorum disk), the second group co...more >>

Hi, I realized an active/passive Windows Cluster from two IBM xSeries346 with Windows 2003 Enterprise Edition SP1 (patched..) and I use like a shared disk an IBM EXP400 (certified..). When Active server go down, passive server can't do automatically the failover, the second server can't ...more >>

Hello Everyone, What is the best solution for my predictament? I'm moving from a single non-cluster SQL2000 STD environment (Server A) to a clustered SQL 2005 STD environment (Server B). Seamlessly as possible, how can I migrate the databases from Server A to Server B? I would like to p...more >>

I am trying to run the 'SQL Server Surface Area Configuration' for our SQL 2005 Cluster Server (passsive/active). The Configuration does point to the Virtual IP of SQL cluster. I still have the following error message. I try to run the Configuration on active node, passive node, remotely, all ...more >>

I have a W2K3 cluster hosting a default and named instance of SQL Server. We want to move the named instance to it's own cluster, how best can I do this? The disks are presented to the nodes from our Dell SAN. Thanx. -Cqlboy...more >>

Hi, Is it possible to use a single storage with multiple SQL Servers?? Regards Ahmad Zia...more >>

We currently have a (2) node active/active cluster with each node ideally hosting (2) virtual servers and their instances. We want to split the cluster into (2) active/passive clusters and move what normally resides on a given node to it's own cluster. Here is the catch. We have cross ser...more >>

Am i able to restore system databases to sql2005 from sql2k SP4 backup dumps? Thanks ...more >>

Hi, I have a new cluster server not sure whether I should install sql 2k or sql 2005. I need to move all prodcution dbs from regular sql2k server to the cluster box. What is the best way to move? Install sql2k first move all dbs including sys dbs and then upgrade to sql 2005. This will ...more >>

Hello all, I have a very bizarre situation with a single instance/two node/W2K3 cluster. The issue I am seeing is that the passive node is starting the sql server services even though the resources are not owned by that node. The restarts are occuring every five minutes. The system log s...more >>

Hi, We are move regular sql 2k sp4 server to a cluster server (Without SAN). In general, what is the best way do setup: active/active notes or active/passive? Thanks ...more >>

What is the registry path for checking if there is a SQLServer installed as a virtual server on the machine. What I am trying to get here is if I logged on to a machine and I want to read from registry if there is any SQL Virtual server installed on this machine or not. I need to know all the ...more >>

Looking to see if I am missing any steps below to adding a SAN disk resource to an Active/Active SQL cluster: -Create Volumes -Present LUNs to both Nodes -Failover Cluster Groups to Node2 -On Node1 Disable ClusDisk Disable Cluster Services Reboot Node1 Rescan for hardware changes Wri...more >>

I'm setting up SQL Mail with Outlook and need to restart the SQL services (mssqlserver and sql agent) on the server to complete the configuration. I would like to do this without causing a failover. Has anyone sucessfully used the commands below to make this work? System: Windows 2003, SQL Ser...more >>

Hello I have set up a new sql 2005 Cluster on a w2k3 box. Now I want to have a Actve Avtive configuration for my cluster boxes. If I try to do this with the config tool I want to set up both nodes to lisenig at the tcp port 1433. If I config it like this the sql server don't start any...more >>

Hello to everyone, Because im little confused with the number of instances in an active/active sql cluster scheme ,can anyone please explain me the right procedure? For example in a cluster with 2 nodes of Advanced Server i have the below : node 1 : SrvClus1\SQLInstance1 ...more >>

I have a Windows 2003/SQL 2005 active/passive cluster. I have two share = drives which are part of the same cluster group. My plan was to place = the data and log files in the first drive and backups on the second = drive. However, I cannot see the second drive from SQL Management = Studio. Thr...more >>

Hi all, I am setting up a 2 instance SQL 2K (32-bit with SP4) cluster on a 2 node Win2003 x64 ENT cluster. Each node has 4 x 3.0 XEONs with 8MB L3 cache and 16 GB RAM. I am looking for info on any switch settings I should use in the startup file for the servers to take advantage of the hard...more >>

After a reboot of one of my node I am currently receiving the following message: The disk associated with the cluster disk resource 'Disk T:' could not be found. The expected signature of the disk was XXXXXXX. If the disk was removed from the server cluster, the resource should be deleted...more >>

HI, I need to evict one node from a two node, two instance SQL Cluster. Beyond failing over all resources and ownership to the surviving cluster node, is there any other configuration change I need to make in SQL server before doing this? Thanks. -- John...more >>

I'm confused. Reading the SQL 2000 Resource Kit, it definitely says I need Enterprise in order to do failover clustering. But reading the product guide on the 2005 version says Standard has clustering capabilities. Is this something new to 2005 or is it a different type of clustering? We'r...more >>

I had SQL 2005 installed on Virtual node on Cluster on IA64 and then uninstalled it. Now I am trying to install SQL 2000 on Virtual node and setup.exe does not launch. When I double click the curse turns into a hour glass and then go back to cursor. It does not do anything. I can run MSI file...more >>

The Physical Disk and Logical Counters do not show up in the cluster or node performance counters. I have verified that DiskPerf is supposed to install the counters at bootup (diskperf -y), but they do not show up in the Performance Monitor. For the record, I have only applied this to the ...more >>

I have two set of SQL Server 2005 cluster servers(active and passive), every time open SQL Server management studio, there will generate error on event view(any client PC or sevrer itself) Event filter with query "select * from __InstanceModificationEvent within 10 where TargetInstance isa...more >>

Hi all, I had 2 questions regarding clusters:- 1. Is it possible to have an Active-Active configuration with 1 instance running 2000 & 1 instance running 2005? 2. Is it recommended or required to have cluster servers part of an active directory domain? Currently we have 2 servers that are pa...more >>

I have a SQL Server 2000 Active/Passive cluster running on 32-bit Windows 2003 server. I'd like a way from w/in SQL to be able to tell which node is currently active. We have several applications, services, etc. which need this information and need to know when the cluster has rolled as w...more >>

Is it possible to set up SQL Server clustering so that only one database would failover or is it an all or nothing type thing. ...more >>

We have been advised that there are performance issues with putting transaction logs on iSCSI targets. Can anyone give more detail/confirm/repudiate this? We are looking at implementing a two node (probably single instance to begin with) SQL 2K cluster with an iSCSI or fibre channel set of...more >>

Hi, Is it possible to install SQL 2005 in a cluster without Active Directory, using ADAM similar to ISA 2004? Regards, David...more >>

This quiz consists of 10 multiple choice questions and 1 extra credit question. This is an "open book" quiz. Feel free to use any resources at your disposal. Feedback is welcome. Ray This posting is provided "AS IS" with no warranties, and confers no rights. --------------------------...more >>

Hey All, I've tried this a couple of times and I keep getting the same result... When I install SQL 2005 Std it only installs the SQL Management Studio and most of the client tools on the actual node that I'm running setup.exe from. The SQL Server works on both nodes but I cannot manage...more >>

Is there a way to setup a cluster on a network running Windows 98SE and Windows XP? We've succeeded at doing things like distributing our files among other computers in the network and mapping their drives for use with built in search functions but now we want to tap processor power of the o...more >>

We have a 2 node cluster (active/passive) Windows 2003 EE, SQL Server 2000 (latest service pack), there are 3 disks (and the C:\ drive), one for data, one for logs and the quorum disks. The SQLServr.exe is located at C:\Program Files\Microsoft SQL Server\MSSQL$DATACLST\Binn When the ...more >>

Hi All, I'm trying to install SQL 2000 (with SP3A) on a Windows 2003 Clustered environment (AMD64). This is a two node cluster, and SQL is being installed as a named instance. I've checked the following: * Using a domain account that is part of the Local Administrators group * Changed all...more >>

Hi, I currently have a two instance SQL Server 2K SP4 (ENT) cluster on MSCS with Windows 2003 ENT SP1. Each instance runs on one of the two nodes of the cluster, which does not have a FC switch. My hardware is currently two Dell PE 6650's connected to an EMC CX300. My upgrade will be to sw...more >>

Hello, I have been building active/passive for many years. I was thinking of doing an active/active, I've seen a lot of problems with active/active. Many people don't recommended. Can you tell me what is the problem with active/active? Why and when should I use active/active? Do you reco...more >>

I am looking to decomission an old AD forest and move all it's resources to a new AD forest. Both forests exist today. I have a 2 node Windows 2003 cluster with 3 resource groups -- the cluster resource group and two (2) SQL 2000 server resource groups. My questions are.... 1) Is this s...more >>

What is the correct procedure to configure 6GB of memory allocation on 64bits plataform? We are using ... * Windows 2003 Enterprise Edition 64 bits (two nodes cluster) * SQL Server 2005 Enterprise Edition 64 bits (active/active) * Two Proliants 585 (4 way dual core Opteron processors, 8 gb...more >>

We have recently installed a new cluster using 4 ways Opteron Processors boxes, we had no problems during installation! We are running an active/active configuration. Now running on production enviroment (medium load), we are experiencing some issues with memory management and t...more >>

On Windows 2003 should we create a separate group for the MS DTC. Would it be OK, to have the MS DTC data on a shared disk that might have some other application or data on it (for example some files). Or should we create a separate shared disk that will hold only the DTC data. If yes, woul...more >>

Hi, I have to setup a Active/Active cluster and I need to know if there has to be made any change in the applications that the user has? For example, direct the app to the other virtual server, etc... Thanks...more >>

Hi! I'm getting an error when trying to start simple distributed transaction. Configuration is Win2k3/SQL2K <-> Win2k3 Cluster / SQL2K --------------------------------------------------------------------------------------------------- [OLE/DB provider returned message: New transaction canno...more >>

Hi, I created 2 nodes active/passive and tested the failover. It worked. I added a 3rd nodes as active. Now nothing can failover to the passive. Any suggestions where I should start troubleshooting. Thanks in advance....more >>

Hi all, I tried to install MS SQL Server 2000 Virtual Server on a Cluster WIN2003 sp1 EE. I start the installation and I insert the next information: 1) Virtual Server Name 2) Virtual Server IP Address 3) Administrative username and password after this information the setup stop without m...more >>

I need to install the full-text engine on an existing SQL Server 2005 cluster virtual instance but can't seem to figure out how. Any ideas? ...more >>

Greetings I recently deployed 2 new SQL clusters for our web environments. We have a legacy cluster that runs windows 2000 server and has active/active clustering with 2 instances of SQL Server. It works well and has worked well for years, but we started to outgrow the hardware, so we acqu...more >>