• mohammed moinudheen (2/21/2011)


    Not in Primary should also be correct.

    That is not true.

    Not in Primary is the same as saying: on every server that is not the primary server. This could include a monitor server. However, the copy job is not installed on the monitor server.

    Edit: it is debatable if there isn't a monitor server. But then again, if there is one obviously correct answer and another "with much doubt" correct answer, what would you choose?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP