Applies To: SQL Server 2014, SQL Server 2016 Preview
Stores one record per secondary database in a log shipping configuration. This table is stored in the msdb database.
Applies to: SQL Server (SQL Server 2008 through current version).
The name of the secondary database in the log shipping configuration.
The ID for the secondary server in the log shipping configuration.
The amount of time, in minutes, that the secondary server will wait before restoring a given backup file. The default is 0 minutes.
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.
The restore mode for the secondary database.
0 = Restore log with NORECOVERY.
1 = Restore log with STANDBY.
If set to 1, users will be disconnected from the secondary database when a restore operation is performed. The default = 0.
The size, in bytes, that is used as the block size for the backup device.
The total number of buffers used by the backup or restore operation.
The size, in bytes, of the maximum input or output request which is issued by Microsoft SQL Server to the backup device.
The filename of the last backup file restored to the secondary database.
The time and date of the last restore operation on the secondary database.