Perry Whittle (9/4/2012)
Usually its set to the secondary destination directory which you can get from the following
exec sp_help_log_shipping_secondary_database 'yourdb'
Thanks, I tried that but did not see the information displayed in any of the columns returned;
there is no column named "secondary destination directory" or close to it.
I ran the above command on the standby server.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]