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

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

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

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?

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

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.

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.

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

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.

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.

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

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

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

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

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