locked
how to tranfser jobs in Mirroring ? RRS feed

  • Question

  • hiiiii...frnds...

    how to transfer jobs in Mirroring ?

    • Changed type Tom Phillips Friday, March 22, 2013 5:41 PM
    • Moved by Tom Phillips Friday, March 22, 2013 5:42 PM Probably better question for Database mirroring question
    Friday, March 22, 2013 2:25 PM

Answers

  • Hello,

    Jobs are at an instance level, you'll need to create them on the mirrored database's instance. You'll want to investigate sys.database_mirroring as part of the job to make sure you're using the one that is the principal.

    -Sean


    Sean Gallardy | Blog | Twitter

    Friday, March 22, 2013 4:04 PM
    Answerer

All replies

  • Hello,

    Jobs are at an instance level, you'll need to create them on the mirrored database's instance. You'll want to investigate sys.database_mirroring as part of the job to make sure you're using the one that is the principal.

    -Sean


    Sean Gallardy | Blog | Twitter

    Friday, March 22, 2013 4:04 PM
    Answerer
  • See the transfer jobs task in SSIS .That will help you.

    If you transferred the jobs to mirror server instance,then you can add first step of every job to check the database in that instance in principal mode.

    If it is,then execute the second step.


    Regards http:\\sqldbatask.blogspot.com MCTS Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

    Tuesday, March 26, 2013 2:22 PM