I am seeing high restore latency in log shipping. All the secondary databases are in standby recovery mode. We don't use these databases for any use. I would like to change them to restoring mode from standby read only mode to overcome this latency issue. I am sure this might not be totally contributing to the latency issue but expecting this might cut short the delay.
What exactly happens while chaging this mode? What happens to the tuf file? In future if I want to get back to standby mode, can I do it?