As an SQL DB Administrator, do you have any checklist which can be done in
daily/weekly/monthly basis for operational continuity.
Such as, verifying backups, shrinking transaction logs, re-indexing with
DBCC commands.

We are currently working on setting up a 2-Node cluster using SQL Server
2005.
Hardware :
                 HP Blade servers : BL 460c (c7000 enclosure)

can one server be passive server of two diffrent failover clustereds?

I am trying to expanding MSDB under SSIS and getting following error:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

We have xSeries 460(x3950-8878) IBM Machine , mounted at win2003 and sql 2005
64-bits.
At future processes, this machine will take over all distributed database
with many application.

I have a big client that made the following big mistake:
They had a two node Active/Active cluster. They evicted node B. A little
later, since they have several similar clusters setup, they also evicted node
A from the same cluster and now the whole environment is down.

We are planning the following setup as part of our Business Continuity
Planning.
We have an active passive cluster in the production and we will also have
the same setup in the DR setup. But the issue is that we need to keep the

We are seeing a very bizarre occurence in the config mgr.  I have a
win2k3/sql2k5 2-node, single instance cluster.  When we look in the config
mgr., the SQL VIP is not present.  I have IPs for the the "passive node," the
Cluster VIP, the heartbeat IP, and the loopback IP.  ...

two nodes, active/active cluster, SQL 2000 built on Windows 2003.
Why so many dbs show offline and how to bring them back????
Thanks so much for your help.

If we have our databases tied to a SAN, why would I consider SAN based
replication vs database mirrroring as a Disaster Recovery solution?
Database Mirroring is free and could accomplish protecting our data and want
to know why would i even think of SAN based replication from EMC ...

Please help.We are installing SQL2000 Ent in a 2 node W2K3 cluster and it
gets pass "Setup has enough information ... and start copying files". After
this it starts copying and stops with an error "Setup failed to perform
required operations on the cluster nodes". I also tried ...

Let me know what you think of the product.Is it worth considering than say
the MSFT cluster ?
Thanks

I have a Active/Passive cluster and have installed the SQL 2005.
What I would like to know, before I proceed with my configurations (since it
is my first time in a cluster environment) is whether I will need to attach
the database (lets call it DBX) to SQL Server on both the ...

Anyone using SAN based replication care to share a rough pricing estimate
for the solution ?

Good day SQL /Cluster GURU's
My question is a general one. I currently have a basic two node SQL cluster
one active/one passive running Sql 2005 standard and windows 2003 server
enterprise. what I want to do is rebuild the two nodes, by first