We currently have a w2003 SQL cluster and would like to add a second cluster
to the infrastructure. Their plan is to have one online serving customers so
the other cluster may have the db restored... Is there a way to get the
databases on both clusters mirrored? We have the cluster to provide HA, I may
need a big hammer to protect the data from developers fingers!
Any suggestions?
Thanks,
Rodney
Rodney,
You might consider log shipping. Here is an article from SQL Server
magazine by Ron Talmage that you might find interesting.
http://tinyurl.com/46h45
Also, transactional replication is used by some to keep another server
refreshed for queries, reporting, etc.
Narayan Kondreddi has a replication FAQ at
http://vyaskn.tripod.com/repl_ques.htm
Russell Fields
"Rodney" <Rodney@.discussions.microsoft.com> wrote in message
news:8A87A93D-889F-477A-9209-C3D5E1EE32F7@.microsoft.com...
> We currently have a w2003 SQL cluster and would like to add a second
cluster
> to the infrastructure. Their plan is to have one online serving customers
so
> the other cluster may have the db restored... Is there a way to get the
> databases on both clusters mirrored? We have the cluster to provide HA, I
may
> need a big hammer to protect the data from developers fingers!
> Any suggestions?
> Thanks,
> Rodney
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment