log_shipping_databases

This table is stored in the msdb database.

Column name	Data type	Description
database_name	sysname	Name of the database being log shipped.
maintenance_plan _id	uniqueidentifier	Maintenance plan ID.