log_shipping_secondary_databases (Transact-SQL)

Applies to: SQL Server

Stores one record per secondary database in a log shipping configuration. This table is stored in the msdb database.

Column name	Data type	Description
secondary_database	sysname	The name of the secondary database in the log shipping configuration.
secondary_id	uniqueidentifier	The ID for the secondary server in the log shipping configuration.
restore_delay	int	The amount of time, in minutes, that the secondary server will wait before restoring a given backup file. The default is 0 minutes.
restore_all	bit	If set to 1, the secondary server will restore all available transaction log backups when the restore job runs. Otherwise, it stops after one file has been restored.
restore_mode	bit	The restore mode for the secondary database. 0 = Restore log with NORECOVERY. 1 = Restore log with STANDBY.
disconnect_users	bit	If set to 1, users will be disconnected from the secondary database when a restore operation is performed. The default = 0.
block_size	int	The size, in bytes, that is used as the block size for the backup device.
buffer_count	int	The total number of buffers used by the backup or restore operation.
max_transfer_size	int	The size, in bytes, of the maximum input or output request which is issued by Microsoft SQL Server to the backup device.
last_restored_file	nvarchar(500)	The filename of the last backup file restored to the secondary database.
last_restored_date	datetime	The time and date of the last restore operation on the secondary database.

See Also