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
About Log Shipping (SQL Server)
sp_add_log_shipping_secondary_database (Transact-SQL)
sp_delete_log_shipping_secondary_database (Transact-SQL)
sp_help_log_shipping_secondary_database (Transact-SQL)
log_shipping_secondary (Transact-SQL)
System Tables (Transact-SQL)
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho