I agree with SSC Journeyman. I like a joke as much as the next guy, but to have to spend five or ten minutes of an otherwise very busy...

As long as I can provide reasonably reliable assurances that the downtime would be on the order of a few seconds, I think I can sell it. The severing-and-reconnecting...

I'm beginning to see that a limited, minimal amount of downtime during the switch is inevitable. So, I'll just have to say, "if you want the new data sooner,...

The data is read-only to the users. The only thing that updates the data is the daily data load we do.

I was thinking about an 'Active\Active' clustering configuration, where...

What about some method (presumably replication or replication-like) where we syncronized the read-only database with the data from the writeable one after the load is completed? I'm not going...

Sandra Skaar (6/16/2009)

---

Recommend benchmarking your performance, showing your decision makers how you can improve performance, and increase customer satisfaction by improving availability.

Slow reporting and other system processes leads to inefficient...

dakman (6/16/2009)

---

How many nodes are in your cluster? It sounds like you have only one active node. Have you considered creating a new instance on the same cluster...

Thanks Pradeep. Trying to cobble together some of those articles and whitepapers on my own is what I've been doing to date, with some marginal success. It seems...

Pradeep: In answer to your question, the data loads we do daily are incremental, not full.

Thank you for all the quick replies. All good thoughts and I agree with everything everyone's said. The problem for me is that, while this is really a...