Great intro - as said before, please consider turning this into a series of "hands on" articles.

thanks

nice article - clean, simple and informative.

Mike

it sounds like a good approach but one we never considered. I'll be interested in trying it at some point.

thanks

mark

There isn't any real limitation to the functionality of MSSQL with log shipping - at least not the "roll your own" kind i've used in the past. In my...

sorry, posted this earlier but apparently i had some issue with my connection. anyway, to be completely honest, we probably should have included it as an option. we...

depending on the availability of the server, you may be able to ship the last log, etc. if the server is completely unavailable, there's not much you can do...

thanks for the comments so far, all are appreciated and noted...

the two servers - primary and secondary are located next to each other on the local lan. In the event that there is a problem with the primary and...

thanks for the comments. you're correct, the setup can accommodate only a single failure in the multiple primary-single secondary situation, but our assessment was that you can go pretty...

thanks for the information. I knew only one license was needed when using Microsoft Log Shipping included in Enterprise edition, but thought that anything outside that required additional licenses....

It depends. sounds like a microsoft answer doesn't it. But seriously, if you include the unused IP address the failed production server gets changed to then yes -...