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 >>