• Do you absolutely require the secondary database to be restored that regularly, have you thought of deferring the copy and\or the restore jobs to run at low usage periods. The rate you are at the moment i'd be surprised if anyone were able to query the database as they'll constantly be disconnected.

    Please post the results of the following query against the secondary server

    exec sys.sp_help_log_shipping_secondary_database 'yoursecondarydb'

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉