Tell me more ×  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?  share|improve
this question add comment  1 Answer  up vote 0 down vote
accepted  Its a bit round about. But first you have the option
in the configuration to change the resulting database to
'standby mode'.  This results in a destination database which is
grey, and is marked as 'Standby / Read-Only'. You can look at
the tables and query it etc.  Take the database offline (TestR