Posted by aleu@vp.pl on 10/01/07 00:44

Roy Harvey (SQL Server MVP) wrote:
> If you loose connectivity for ten minutes it would have two impacts.
> One, once the connection is re-established there is an additional
> delay while the backlog is cleared. Two, you could not clear the
> transactions from the log on the source system until after the
> connection is re-established and the backlog cleared.
>
> I don't have the hands-on experience with mirroring to have a good
> feel for bandwidth requirements, but the major variable is the level
> and nature of database activity that only you know. Reading a bit
> more from some googled items I am more and more thinking you would be
> restricted to asynchronous. If you take a look at your transaction
> logs they should give you some idea how much data has to be pushed
> over the link.
>
> I suggest googling sql server 2005 mirroring and reading up. And
> hoping someone with hands-on experience joins the discussion!
>
Thanks Roy. It is time to do some serious reading.

Regards,
AL

[Back to original message]