Hi All, We have a single node cluster (formally 2 node) which is running SQL 2000. My question is this: wanting to remove the clustering component entirely from the picture, can I simply disable the cluster service and start SQL as normal? We have no need to any clusting on this server ...more >>

I'm installing SQL2005 ent. on a active/passive win2003-sp1 2 node cluster. Just before installation finishes I get an error: Failed to install and configure assemblies C:\Program Files\Microsoft SQL Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificationservices.dll in t...more >>

What's the best way to backup cluster and restore it incase of outage? TIA Env: MSCS 2000 OS: Win2000 Adv Srv SQL2k ...more >>

When installing SQL 2005 on a 2 node cluster, the install fails saying setup on the remote machine failed, check the task scheduler log. The log on the remote machine says "Unable to start task....Access is denied". Any idea how to get around this? Environment is DL585, Windows 2003 x64 s...more >>

Hi, If the SQL environment is not going to use distributed transactions, is it still necessary to configure a DTC resource on the cluster ? Thanks...more >>

Hi, I would actually want to set up 2 exactSQL SERVER on 2 different physical machine each with their own hardwares so that if one is down , the application could immediately switch over to the working computer as well as part of my Diaster Recovery Procedure (DRP) I know that clustering...more >>

If I have a teamed adapter in a cluster, shouldn't I be able to remove that node from the cluster, break the team and re-add the node? It seems to fail whenever I try to add the node back, with the team broken. ...more >>

Does anyone has a VBS to backup Cluster? Thanks much! ...more >>

Hi All, Can I set up a cluster on my PC (through virtual server) Can someone point me out the docs of how to do it? Thanks much. ...more >>

I have a 2003 Enterprise Ed 2 node cluster with each node having 8 gig of memory. On each active node, I am running a single named instance of sql server 2000 enterprise wiath latest svc packs. The boot ini on the servers is currently configured with the /PAE switch only. Each SQL named...more >>

Can someone point me out SDK for clustering on Win2000? I am planning to invoke Cluster API's using VBS... Thanks in adv. ...more >>

Hello, We have a 2 node active/passive SQL 2005 cluster and were wondering if anyone knows if there is a solution which would allow someone to be notified automatically should the active node failover to the passive node? Maybe an email being sent? A page? Any ideas? Regards ...more >>

I had an earlier post about the SQL Server Agent on a SQL cluster stopping every now and then. I noticed that there is an option under SSA properties to "Restart Agent if it stops", but it's greyed out. Anyone know how I can have the Agent restart itself if it stops? I think the cluster s...more >>

Hi All, Want to seek advice and experience from all of you. What is the recommended RAID Solution for SQL Cluster on SAN, is it RAID 1+0 or RAID-5? We just upgraded from RAID 1+0 to RAID 5 and since then we are getting hiccups on the Cluster. If there is any connectivity failures on the Drives (...more >>

I am new to clustering. I will be setting up a 2 node cluster using W2k3 EE and SQL 2005. I have a Dell PE 2850 and Dell PE 1850 for the servers, each containing one 73 GB HD and a PowerVault 220 with 4-73GB HD’s for the shared Drive. I am uncertain of how to configure the shared drive. Can ...more >>

Can someone point out resource for configuring MSCS on SQL2005 and Win2k3? TIA ...more >>

Cluster active-active. The node B was reinstalled after a hardware failure. Now the node B is ok. The failover is ok, except because I receive the message"The Microsoft Clustering Service failed restore a registry key for resource SQL Server " when I move the Instance B from Node A to Node B....more >>

Hi, all We are preparing to have sql2005 failover cluster. I have no experience on it. My question is that 1.there is any complete step by step docs for sql2005 installation on win2003 cluster server? 2. there is any training class in new york that I could attend for 1 day or 2 just for sql20...more >>

Can u install FTS later on? I have a clustered env. and due to failure in registering FTS the entire install is rolling back? so perhaps I can delete the FTS Resource and install it later... TIA ...more >>

I recently rebuilt my cluster (Server 2003 + SP)and installed SQL Enterprise 2000 + SP3 on both matching nodes. Everything seems fine, except on occasions the SQL Agent just shuts down with no error messages in the logs and I have to go into Cluster Manager (or Enterprise Manager) and restart i...more >>

hello, We're running W2000 sp4 fr/ SQL 2000 SP3 fr and get error 17122 in the application event log every time SQL is brought up. The error text reads "initdata: Warning: Could not set working set size to 1168512 KB". What does this really mean, is it harmful and how can I correct it? Thanks...more >>

I get strange behavior when I install 2005 into a cluster. I have 2 disk resources (on a SAN) that I have added to a SQL group. When I install 2005, I don't ever specify to use the log disk, I only tell it to put the data on the data disk. The strange part is, after it installs, the log dis...more >>

Hello Friends I have a project that will use Failover Cluster for SQL 2005 and NLB for the web server front-end (using IIS). That web application will be developed in-house. there are any special programming considerations that the programmers must embed in the application in order to s...more >>

2 Questions Actually! 1. I know how to move all the system DB's in 2000, but I am a bit confused as to how to accomplish this in 2005. I need to move: Master Model MSDB I've already moved Temp. 2. Now, there is this other DB, called the resource DB, which they tell you not to re...more >>

I just completed an install of SQL 2005 Standard into a newly formed cluster. I basically installed every option for SQL 2005 Server, however, the only resources added to the cluster group were SQL Server, SQL Agent and SQL Server Fulltext. I would have thought reporting services would hav...more >>

We are planning a recycle of our SAN to which our active/passive 2-node SQL cluster is attached. Is there anything special to be aware of? We will do the following steps: Pause the passive node using Cluster Admin, stop SQL service Power down active node server power down passive node serv...more >>

My production cluster disks are corruptd - i would like to find out how to restore from backups I have all system backups and mdf and ldf files of the databases - I would like to keep the logins, jobs etc Thanks ...more >>

Hi, We have a cluster (2node, 8Way, 8GB) running windows 2000 Advanced. We would like to upgrade to windows 2003 Enterprise Edition Whats the easiest way to accmplish this ? what are the options ? are there any links ? ...more >>

We currently have SQL server EE running on Windows Server 2003 EE in a 2 node active/passive cluster. We want to restart periodically but not too often. What is the best way to do this? What I've been doing is move the resources to the inactive side of the cluster then rebooting the passive no...more >>

Hello to all, I am currently working on creating a Windows 2003 server cluster (3 nodes) with the intent that it serve our web app which requires multiple SQL databases. The question I have is this: How can I configure load balancing for this? It seems that clustering services only allows 1...more >>

I have a 4 node Windows 2003/SQL 2000 cluster that started out as a three node cluster. I just added another node and new instance. Everything went great on the Windows/cluster side, everything fine on the SQL side for that instance. When I went to add the new node to the other two inst...more >>

My application record the SQL Timeout in the log file. The application server calls SQL on cluster via ADO. The error is always when the batch processing is running. Can anyone here advise me on how do I expand the time-out on SQL cluster? I am using SQL 2000 SP3 Best Regards, Naruphon ...more >>

I would like to know if I can move my active/passive SQL clusters into a more cost effective four node cluster (3 active and 1 passive). Is there a matrix or document somewhere on Microsoft's site that indicates what configurations are officially supported and considered "best practices"? ...more >>

Hi, In the company where I Work, decide to implement a sql server cluster. I want to ask, I somebody know any issue I have to consider or any sites that i need to visit before implement it. At this moment, i have a server running win2k server sp4, sql server 2000 sp3 std edition. Thanks ...more >>

I have an active/passive cluster involving 2 machines. I have 3 instances running on the production server. One of the drives allocated to instance 2 was running out of space so I decided to move one of the larger databases to another drive that can handle its size. The drive that I was goi...more >>

I have set up a multiple instance SQL server and I'm trying to understand how both instances are able to use the same MSDTC resource. Specifically, Server 1 is the primary host for instance 1 (server 2 is the backup for instance 1). Server 2 is the primary host for instance 2 (...more >>

Hello, I've set up a few two node active/passive SQL 2000 clusters in the past but now a client is asking for a two node SQL 2005 active/passive cluster. I'm assuming this is still possible in 2005 but just can't seem to find any good resources related to SQL 2005 clustering. Can anyone p...more >>

We will be setting up a Windows 2000 SQL server on a two node 2003 Cluster connected to an HP SAN. Reading through the whitepapers and watching the webcast on how to setup everything says to keep the data files on a seperate disk from the quorum drive. This will not be a problem, however...more >>

We have a SQL 2000 SP 3a Active/Active Cluster running on Win2K3 SP1 servers. Servers are big iron - plenty of memory, processors, GB Network, etc. Every once in a while (usually 3 or 4 times a day), I will see a rash of Source: ClusSvc Category: Event Logger Type: Warning Event ID: 1137 ...more >>

New to Windows MCS 2003 is the Majority Node Set option, does anyone have any experience where Majority Node is better than Quorum or vica versa? ...more >>

Books online says clearly that on the SQLServer agent properties (Connection tab) you should select Windows authentication if you are running on NT or Windows 2000. It doesnt't say why. My version of Books doesn't give a recommendation for Windows 2003. Most of our instances don't seem to ca...more >>

Hello, We are implementing clustering (Active/Passive) in our Production environment. So we will have two windows server 2003 for SQL SERVER. (ProdDbServer1 and ProdDbServer2) I will install SQL Server on both the machine and i will create my database (FinDB) on both the machine's SQL SERVER...more >>

Hello All. I need to set up quite a large SQL System 2005 system that needs to deal with 40,000 concurrent users, and one of the tables will contain blob data. 40,000 users throwing around Mb's of data at the same time worries me a little bit! My question is to do with Database Clustering a...more >>

Strange issue... I have a 2-node SQL Server 2000 Cluster with SP4 applied. Everything works fine but the Veritas BackupExec program can't find the SQL Server. When I use Computer Management to connect to the cluster by the cluster name (and also to the active node of the cluster), I only found "...more >>

Hi , When I finish to create one non clustering index on of of my table , I found out that the size of the hard disk increase amazingly. I decide to drop the this index but the hard disk size did not back to original size before that. What should I do next ? Please help -- Trav...more >>

In: Clustered SQL Server do's, don'ts, and basic warnings http://support.microsoft.com/default.aspx?scid=3Dkb;en-us;254321 In Section: Important cluster service administrative rules. "Warning If you ignore any of the following rules, you will need to reinstall Microsoft Cluster Service. =B7If y...more >>

hi, I have a windows 2003 sp1 cluster running sql2005. the DB is installed on S: and i have a R: & U: drive letter that is both differend disk and runs fine in the cluster. But i can not see those disks in sql 2005 why ?? the disks are in the same resource group (SQL) where can I choose t...more >>

I am just trying to valid that our process is correct for moving all clustered groups off of a node for maintenance (e.g. rebooting a node). We have three different clustered configurations in our environment. Here is each move process for each configuration. 1. Quorum Group (includes DTC) S...more >>

Hello, We are restoring our production SQL cluster to an isolated DR site. The server and SAN hardware are the same, the domain is the same, all of the IP addresses are the same because the network is isolated. Typically, we back our production servers up to tape and restore them on top ...more >>

I have many event error about SQL server, this errors report comunication lost link but all cards (Heart bit include) are online, this error apear randomize, some times, some days, once time at day or two time in the same day. I check all fisical infrastructure, and the EVENT VIEWER SYSTEM ...more >>