• We do it every year once, we have very huge prod DB in log shipping. The client wants to get copy of then live prod db for their testing and reports. We copy our master files and logshipping undo tuf file soemwhere else on DR. Restore the LS db in recovery mode and get the backup to restore later with diff name.

    Then remove just restored DB, and restore the copied files in similar fashion. I thought we were cheating:unsure: but happy to know we are not alone now;-)

    It is much less time comsuming than getting backup from prod server.