Peter Maloof (1) [Avatar] Offline
#1
Hi, Rod. I'm getting a lot out of your book. Kudos to Brent Ozar for recommending it.

I have a question regarding transaction log shipping and database mirroring. I understand that there's no disk-based central point of failure (like there is with database clustering), but wouldn't the network be a single point of failure? I'm assuming none of the servers have multiple NIC's.

I know it's kind of a picky question, but I just want to make sure I'm understanding the concepts.

Thanks again for the book.

Peter
RodColledge (1) [Avatar] Offline
#2
Re: Central Point of Failure for Log Shipping and Mirroring?
Good point Peter, although I guess network failures are more transient, and when fixed, don't lead to a loss of data, compared to the loss of a disk(s). Further, disk failures are typically more frequent, and permanent in nature.