Perry Whittle (9/4/2012)
Marios Philippopoulos (9/4/2012)
Perry Whittle (9/4/2012)
the column is called 'backup_destination_directory'That location contains the log backups copied to the standby from the principal. There is no standby file there.
yes it does and by default will have the TUF file too unless someone has deleted it 😉
When the log shipping plan was created did the wizard backup and restore the database for you or was the database already initialised?
I had initialized it previously using a manual "RESTORE DATABASE ... WITH STANDBY ..." command.
Is that why it is not showing up?
__________________________________________________________________________________
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]