log shipping job

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tulip - 20 Mar 2008 16:13 GMT

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

Reply to this Message

Anith Sen - 20 Mar 2008 19:15 GMT

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.

Signature

Anith

Reply to this Message

Anith Sen - 20 Mar 2008 19:20 GMT

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.

Signature

Anith

Reply to this Message

tulip - 20 Mar 2008 21:40 GMT

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

> 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
[quoted text clipped - 3 lines]
> Search for an article by Ron Talmage on log shipping with SQL 7.0 and you
> might find some more details about these tables.

Reply to this Message