Let me say that I like log shipping, for me as a DBA it ensures I have a set of backups in a different location, hopefully a different site to my main data centre. Mostly I like log shipping because all of my backups get restored as soon as after being taken and as we all should know “ The only good backup is one that’s been successfully restored” I’ve log shipped since SQL 6.5, I don’t use a third party solution, I mean it’s not difficult is it? 1.    Take backup 2.   ...(read more)

http://sqlblogcasts.com/blogs/grumpyolddba/archive/2016/11/15/when-it-s-gone-it-s-gone.aspx