Has anyone configured log shipping to work in the following scenario: Log ship from the Primary DB to the Secondary DB, then configure log shipping from that Secondary DB to another DB? I realise that the secondary DB sits in a warm standby mode therefore will not allow you to backup the logs, but if you could modify the restore job on the secondary to firstly restore the logs from the primary, then change the state of the db, possibly with the RESTORE DATABASE MyDBName WITH RECOVERY command, then backup the logs and return the db to the warm standby state? The third server would then be able to pull the logs from the secondary db and restore to the third db. The logic seems sort of ok, except I'm not sure how to turn change the secondary db back into the warm standby state? Any ideas or comments would be really appreciated!