High availability with existing cluster

I have a active/passive clustered SQL Server 2005 Enterprise. If the
data file becomes corrupt, I've lost my high availability and because
the database is over 200GB, a restore operation will take hours. Does
anyone have any suggestions for creating a warm stand-by in a
clustered environment? Is this even possible, since the stand-by would
need to become the virutal server resource owner?"Curtis" <curtmorrison@.hotmail.com> wrote in message
news:9d55337f-76a2-49f3-b1c8-18b17d09ab16@.b64g2000hsa.googlegroups.com...
>I have a active/passive clustered SQL Server 2005 Enterprise. If the
> data file becomes corrupt, I've lost my high availability and because
> the database is over 200GB, a restore operation will take hours. Does
> anyone have any suggestions for creating a warm stand-by in a
> clustered environment? Is this even possible, since the stand-by would
> need to become the virutal server resource owner?
Hi
Database corruption will be an issue that is not covered by hardware
clustering, and may require more time for recovery if that does occur. You
can look at log shipping or database mirroring, but for this to take over
you would need to change the client and possibly an active/active cluster.
You can also look at online restores to possibly make the system available
quicker in the event of having to restore. See
http://www.microsoft.com/sql/technologies/highavailability/default.mspx
John

Hiding column heading

I have a report that includes a group that I have hidden. the group becomes
visible using a toggle on a textbox in the group header. I would like to
place a column heading in the header row for the group detail. I want this
header to only appear when the detail is visible. I can use the visibility
property of a text box but if I do that then that affect any color or lines
on the group header row
SO
My question is : Is there a way to use the IIF function to evaluate whether
a particular textbox is visible?I don't think you can access the properties on the fly... At least I haven't
seen an exmple of how to do it ...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Mardy" <Mardy@.discussions.microsoft.com> wrote in message
news:2424391D-05DD-46F7-A424-B1D965219647@.microsoft.com...
>I have a report that includes a group that I have hidden. the group becomes
> visible using a toggle on a textbox in the group header. I would like to
> place a column heading in the header row for the group detail. I want this
> header to only appear when the detail is visible. I can use the
> visibility
> property of a text box but if I do that then that affect any color or
> lines
> on the group header row
> SO
> My question is : Is there a way to use the IIF function to evaluate
> whether
> a particular textbox is visible?