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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 log_shipping_plan_history

Author  Topic 

mfemenel
Professor Frink

1421 Posts

Posted - 2006-07-25 : 09:49:05
Looking at the log_shipping_plan_history table in msdb and I noticed that every 1/2 hour overnight, it's trying to copy the same file (which has already been restored) repeatedly. It's not really causing an issue, I'm just trying to figure out why it's doing this. Anyone have experience with this?

Mike
"oh, that monkey is going to pay"

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-07-25 : 10:06:12
is it scheduled to run every 30 minutes? trying to sync perhaps?


--------------------
keeping it simple...
Go to Top of Page

mfemenel
Professor Frink

1421 Posts

Posted - 2006-07-25 : 10:30:04
It actually turns off (copy & restore) at 2 a.m. but I see 1/2 hour increments after that. Also, it's already copied/restored the file it keeps trying to pull over. I just find it unusual.

Mike
"oh, that monkey is going to pay"
Go to Top of Page
   

- Advertisement -