Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    NY
    Posts
    3

    Red face Unanswered: simple log shipping

    Hello,

    I'm having some trouble with simple log shipping. I think I have everything setup correctly, but when I test out the job to back the T-Log and restore it to the Standby server, the job itself doesn't stop running until I cancel it. The T-Log gets applied and the job just keeps on executing.

    I set the parameters in the job to run every 60 mins for 12 hours. I checked under process info and it seems to be awaiting command. Has anyone else come across this problem and maybe have some suggestions for me.

    Thanks so much for your help !!!

    Monika

  2. #2
    Join Date
    Sep 2003
    Posts
    522
    check in task manager for sqlmaint processes. see how many of those you can find. we've had a similar fluke here once a while back. there were 7 instances on that utility running at the same time.

  3. #3
    Join Date
    Sep 2003
    Location
    NY
    Posts
    3
    ms_sql_dba,

    Thanks for your reply. I checked and I don't see any sqlmaint processes in task manager.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •