log shipping job

  • does anyone know about these tables on msdb: backup_movement_plans and backup_movement_plan_database? Are they related to log shipping jobs? When we create the log shipping jobs(copy and load) using script, how the data in those tables get populated? and how the job know to retreive the data from the tables? thanks

  • Yes, they are log shipping related. Log shipping backup transactional logs on the source server, ship them to the target server, then, restore logs there.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply