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
I don't think these tables have anything to do with log shipping. Do you
have any third party applications running on or accessing the database?
Perhaps one such application might have added these tables for handling some
administrative tasks.
Anith
|||Just found that these are tables from SQL Server 7.0 version which I hadn't
thought about before. Yes, these are valid log shipping related tables in
SQL Server 7.0. The log shipping scheme has changed considerably with SQL
2000 however.
Search for an article by Ron Talmage on log shipping with SQL 7.0 and you
might find some more details about these tables.
Anith
|||we are currently on 2000 SE version, since has no EE, we have to create the
jobs to do log shipping (copy and load), so do those tables need to manually
created also? thanks
"Anith Sen" wrote:

> Just found that these are tables from SQL Server 7.0 version which I hadn't
> thought about before. Yes, these are valid log shipping related tables in
> SQL Server 7.0. The log shipping scheme has changed considerably with SQL
> 2000 however.
> Search for an article by Ron Talmage on log shipping with SQL 7.0 and you
> might find some more details about these tables.
> --
> Anith
>
>