SAN Replication vs Database Mirroring

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 or Hitachi
for that matter.
Please let me know. Thanks
Database Mirroring is a data protection/high availability solution on the
database level...And with a witness in place gives you automatic failover.
I don't now San replication....but i don't think it can give you the same
options.
|||You may have other data outside of SQL on the SAN that needs replication.
Also, SAN replication is typically implemented as part of a geo-stretch
failover cluster, which fails the entire serer. Mirroring works at the
individual database level only.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Hassan" <hassan@.hotmail.com> wrote in message
news:uJ%23oJh0wHHA.4736@.TK2MSFTNGP04.phx.gbl...
> 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 or
> Hitachi for that matter.
> Please let me know. Thanks
>
|||Just to add to what others have said.
If you have one or a few databases to replicate, Database Mirroring is fine.
What if you have 10's, 100's, or more databases to replicate? Setting up and
maintaining numerous Database Mirroring instances has considerable support
overhead. One advantage of SAN-level replication is that it's largely
transparent to the DBAs.
Linchi
"Hassan" wrote:

> 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 or Hitachi
> for that matter.
> Please let me know. Thanks
>
>
|||In addition to the above mentioned differences, I decided towards using
DB mirroring because this seams like a more portable solution with a
much wider knowledge base.
If you start having problems with the SAN replication, you'd pretty much
be stuck with the proprietary system that only their support can help
you.
*** Sent via Developersdex http://www.codecomments.com ***