log_shipping_plan_databases System Table - SQL Server 2000

This table is stored in the MSDB database.

Column nameData typeDescription
plan_iduniqueidentifierThe plan ID for the maintenance plan that exists on the Secondary.
source_databasesysnamePrimary database of a log shipping pair.
destination_databasesysnameSecondary database of a log shipping pair.
load_delayintDelay (in seconds) before restoring a transaction log after it is transferred to the secondary server.
load_allbit1 = Load all copied transaction logs.
last_file_copiednvarchar(500)File name of last transaction log copied.
date_last_copieddatetimeDate that last transaction log was copied.
last_file_loadednvarchar(500)File name of last transaction log loaded.
date_last_loadeddatetimeDate that last transaction log was loaded.
copy_enabledbitAllow copying of transaction logs. 0=disable; 1 = enable.
load_enabledbitAllow loading of transaction logs. 0=disable; 1 = enable.
recover_dbbitRoll back all uncompleted transactions after restore. 0=false; 1=true.
terminate_usersbit1 = Terminate database users.