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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment