I have set up log shipping with my database to make a backup. The backup copy of the database is in a status called '(Restoring...)'.
I understand this is to be expected? Is there a good way I can tell whether the log shipping is actually working?
I have run the stored procedures sp_help_log_shipping_monitor_primary, and sp_help_log_shipping_monitor_secondary which are all good.
What I had in mind was trying to understand what the restoring mode is. If there is a way of backing up and restoring that database so I can take a separate copy of it to check?
In an emergency, how do you take it out of the restoring mode?