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