Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
maryxu
Starting Member
36 Posts |
 Posted - 2008-03-20 : 11:07:28
|
| 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 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-20 : 11:17:29
|
| No. You need to study BOL. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-20 : 13:41:18
|
| The log shipping tables are prefixed by log_shipping_.Don't create the job via scripts. Use the maintenance plan wizard to setup log shipping.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
maryxu
Starting Member
36 Posts |
Posted - 2008-03-20 : 17:20:54
|
| 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 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-20 : 21:49:03
|
| Everything needs to be created manually when you don't have EE.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
log shipping job