Need a real-time replication mechanism.

Need help here.
We need to have two database servers in separate facilities kept up to date.
With a disaster we start using the second one.
SQL replication won't do it because not all tables have primary keys.
Data mirror won't work for the same reason.
Likewise Lakeview Tech.
Anyone have any thoughts on how we can do this? Livevault is one thought we
have. Doesn't EMC have something for hardware based replication?
--
burt_king@.yahoo.comHi
Most SAN vendors have hardware/software solutions to replicate SANs. EMC
have MirrorView http://www.emc.com/products/software/mirrorview.jsp,
Replication Manager etc..
John
"burt_king" wrote:
> Need help here.
> We need to have two database servers in separate facilities kept up to date.
> With a disaster we start using the second one.
> SQL replication won't do it because not all tables have primary keys.
> Data mirror won't work for the same reason.
> Likewise Lakeview Tech.
> Anyone have any thoughts on how we can do this? Livevault is one thought we
> have. Doesn't EMC have something for hardware based replication?
> --
> burt_king@.yahoo.com|||Hi
If you have an EMC DMX SAN, SRDF is the way to go.
With SRDF, the write is committed at both the primary and secondary site
before Windows/SQL Server gets the write confirmation.
Regards
--
Mike
This posting is provided "AS IS" with no warranties, and confers no rights.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:2EA69112-E1B2-4FF7-9A54-29A22B58D25E@.microsoft.com...
> Hi
> Most SAN vendors have hardware/software solutions to replicate SANs. EMC
> have MirrorView http://www.emc.com/products/software/mirrorview.jsp,
> Replication Manager etc..
> John
> "burt_king" wrote:
>> Need help here.
>> We need to have two database servers in separate facilities kept up to
>> date.
>> With a disaster we start using the second one.
>> SQL replication won't do it because not all tables have primary keys.
>> Data mirror won't work for the same reason.
>> Likewise Lakeview Tech.
>> Anyone have any thoughts on how we can do this? Livevault is one thought
>> we
>> have. Doesn't EMC have something for hardware based replication?
>> --
>> burt_king@.yahoo.com