February 19, 2003 at 8:20 am
Hi,
I would like to know there is any good software on the market to replicate MS SQL databases from a production server to a contingency server in real, near real time.
Thanks
John
February 19, 2003 at 8:47 am
The built in replication or log shipping won't work for you?
Andy
February 19, 2003 at 9:23 am
Andy,
Here are my concerns: The log shipping is not real time; and SQL replication will make the configurion and backup/restore very difficult when replicating lots databases on the same box.It's why I am looking for a third-party software to do that.
Thanks a lot for your time.
JX
February 19, 2003 at 2:39 pm
There is at least one 3rd party product that does replication using triggers - not sure how that would be any better than built in, but its there. You could also look at software that does block level copying to move data.
I agree that replication adds some complexity, but its pretty stable AND supported by MS. SQL2K better than 7 about supporting schema changes to replicated objects. Then you're down to latency of anywhere from 1-5 seconds on average, depending on volume and transaction size of course.
Often the delay associated with log shipping is considered a plus, a chance to stop mistakes before being applied to the backup server.
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply