Export (0) Print
Expand All
Expand Minimize

log_shipping_plan_databases

SQL Server 2000

This table is stored in the msdb database.

Column name Data type Description
plan_id uniqueidentifier The plan ID for the maintenance plan that exists on the Secondary.
source_database sysname Primary database of a log shipping pair.
destination_database sysname Secondary database of a log shipping pair.
load_delay int Delay (in seconds) before restoring a transaction log after it is transferred to the secondary server.
load_all bit 1 = Load all copied transaction logs.
last_file_copied nvarchar(500) File name of last transaction log copied.
date_last_copied datetime Date that last transaction log was copied.
last_file_loaded nvarchar(500) File name of last transaction log loaded.
date_last_loaded datetime Date that last transaction log was loaded.
copy_enabled bit Allow copying of transaction logs.

0 = Disable copying.
1 = Enable copying.

load_enabled bit Allow loading of transaction logs.

0 = Disable loading.
1 = Enable loading.

recover_db bit Roll back all uncompleted transactions after restore.

0 = FALSE
1 = TRUE

terminate_users bit 1 = Terminate database users.

Show:
© 2014 Microsoft