all groups > sql server replication > january 2005 >
You're in the

sql server replication

group:

byte by byte level replication versus sql server replication


byte by byte level replication versus sql server replication Pari
1/20/2005 6:39:08 AM
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


Re: byte by byte level replication versus sql server replication Pari
1/20/2005 7:19:07 AM
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

[quoted text, click to view]
Re: byte by byte level replication versus sql server replication Hilary Cotter
1/20/2005 9:44:54 AM
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
[quoted text, click to view]

Re: byte by byte level replication versus sql server replication Hilary Cotter
1/20/2005 1:39:35 PM
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
[quoted text, click to view]

AddThis Social Bookmark Button