Urgent : Data Synch between Sanfranscico and Vegas -- sql server replication

DKRReddy
4/13/2006 5:38:43 PM

We are planning to setup Production Database servers in the new location
for disaster recovery.
Following is my requirement.Please advise me.

LogShip Setup from SF to Vegas
Log Backups runs every 15 minutes
Log Backup size 30GB/Day, 2GB/15minutes ,

Can SQLLite backup solution will help in backup and restore of logs
(compressed).
SQL logship is taking very long time for shipping logs from Sanfrancisco
and Vegas.

Please let me know
Thanks.

Michael Hotek
4/14/2006 6:09:09 PM

Yes, it can help simply because your bottleneck is in the network and
Litespeed compresses the backups therefore less data is being transmitted.
But, you would have to code the entire log shipping process yourself.

--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.

[quoted text, click to view]

sql server replication : Urgent : Data Synch between Sanfranscico and Vegas