SQL Log shipping copy
This might take you 10 minutes to read.
This is a two blog post divided into two posts. The second will be published within a week from this one. The script was created a while ago and has some minor updates.