Post reply

Log shiping Schedule works funky

  • May 12, 2006 at 8:29 am

    #113434

    Hey guys, thanks very much with your previous help on my backup issue. Works perfect now.

    However i ran into new problem I have had log shipping implemented and it worked fine till rescently i have tried to modify schedules. The job is scheduled as: Occurs every 1 days, every 15 minutes between 5:15 am and 11:45 pm.

    However when you look at the job history, it manages invoke itself at 3:15 am and then quiet till 5:15 am... and this messes up the logick in full-and-logs shipments.

    Now is there some garbage left somwhere and i can't see it (like old schedule info and etc?)

    PS. again it is MS SQL 2000 Standard ed.

  • May 14, 2006 at 11:44 am

    #637747

    Did u try to delete the job and recreate it as new one with the new schedule ???

    Get busy living ....or get busy dying....

  • May 15, 2006 at 8:26 am

    #637874

    Yep. tried deleting the schedule and recreating it. Same story.

    seems like some *old* schedule stuck somewhere. Is there a way to look at all scheduled jobs in a file? registry?

    thanks

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

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