Thursday, February 16, 2012

byte by byte level replication versus sql server replication

Hi
Can anyone give me a helpful link or information on the pros and cons on the
"byte by byte level replication" versus "sql server transaction replication".
Requirement:
I need upto second replication to a geographically remote site, so I was
considering sql server transactional replication versus byte by byte data
level replication between the geographically remote servers.
What are the pros and cons?
Any kind of information would be of help.
Thanks
For software solutions - Byte by byte is not good for write intensive
operations - I find it doesn't scale well.
For hardware solutions look at products like EMC's SRDF. Its very expensive.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Pari" <Pari@.discussions.microsoft.com> wrote in message
news:D3925A66-6ED5-4795-AE50-B5BA56F6D7B4@.microsoft.com...
> Hi
> Can anyone give me a helpful link or information on the pros and cons on
the
> "byte by byte level replication" versus "sql server transaction
replication".
> Requirement:
> I need upto second replication to a geographically remote site, so I was
> considering sql server transactional replication versus byte by byte data
> level replication between the geographically remote servers.
> What are the pros and cons?
> Any kind of information would be of help.
> Thanks
>
>
|||Hi
When you say software solutions, what does it mean? It has to have a
software on a hardware box even EMC SRDF is a remote replication software
solution.
Is the Data Replication Manager (DRM) from HP on XP hardware comparable to
EMC's SRDF?
can you please clarify the hardware and software solutions difference.
Thanks
"Hilary Cotter" wrote:

> For software solutions - Byte by byte is not good for write intensive
> operations - I find it doesn't scale well.
> For hardware solutions look at products like EMC's SRDF. Its very expensive.
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> "Pari" <Pari@.discussions.microsoft.com> wrote in message
> news:D3925A66-6ED5-4795-AE50-B5BA56F6D7B4@.microsoft.com...
> the
> replication".
>
>
|||A software solution which does a byte by byte copy is DoubleTake. I believe
it has a driver which sits between your os and the disk array and monitors
byte activity, then it copies deltas to the destination server.
Data Replication Manager sounds similar to EMC's SRDF, but I am not sure if
either can run on XP.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Pari" <Pari@.discussions.microsoft.com> wrote in message
news:46724538-E7A1-46FC-A6BF-A786DF7B4508@.microsoft.com...[vbcol=seagreen]
> Hi
> When you say software solutions, what does it mean? It has to have a
> software on a hardware box even EMC SRDF is a remote replication software
> solution.
> Is the Data Replication Manager (DRM) from HP on XP hardware comparable to
> EMC's SRDF?
> can you please clarify the hardware and software solutions difference.
> Thanks
> "Hilary Cotter" wrote:
expensive.[vbcol=seagreen]
on[vbcol=seagreen]
was[vbcol=seagreen]
data[vbcol=seagreen]

No comments:

Post a Comment