February 21, 2011 at 9:05 pm
Comments posted to this topic are about the item LogShipping
February 21, 2011 at 9:06 pm
Not in Primary should also be correct.
M&M
February 21, 2011 at 11:51 pm
mohammed moinudheen (2/21/2011)
Not in Primary should also be correct.
Got it right, but was a bit confusing, as I agree that there are multiple correct answers.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 22, 2011 at 12:09 am
Nice easy question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 22, 2011 at 12:10 am
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
February 22, 2011 at 3:06 am
I like it when I learn something new from this, had to do a bit of reading but got there in the end. Yay!
Agree regarding "Not in Primary" being the wrong answer, although worded in such a way to catch the unwary out, the fact is that the Monitor server (if employed) would not have a copy.
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
February 22, 2011 at 6:42 am
all of these answers could be correct.
---------------------------------------------------------------------
February 22, 2011 at 6:46 am
Koen Verbeeck (2/22/2011)
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.
How so? Without more detail in the question Not in primary can only mean its not installed on the primary, which is a correct answer.
---------------------------------------------------------------------
February 22, 2011 at 6:48 am
You are very true George.
Maybe the OP was giving a point for peoples ability to filter out the wheat from the chaff and not be pedantic...
😉
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
February 22, 2011 at 6:52 am
george sibbald (2/22/2011)
Koen Verbeeck (2/22/2011)
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.
How so? Without more detail in the question Not in primary can only mean its not installed on the primary, which is a correct answer.
I understand your point.
I was looking at the phrase "Not in Primary Server" from a logical (mathematically speaking) view, where you can translate "Not in Primary Server" into "Installed everywhere else".
A little farfetched, but hey, I didn't have my morning cup of coffee when I posted that...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 22, 2011 at 7:00 am
my other point would be the monitor can be installed on the secondary server.......:-)
---------------------------------------------------------------------
February 22, 2011 at 7:01 am
george sibbald (2/22/2011)
my other point would be the monitor can be installed on the secondary server.......:-)
Let's just conclude that the question could have been phrased better 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 22, 2011 at 9:23 am
thanks for the question
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 22, 2011 at 9:46 am
new the right answer but talked myself into the wrong answer thinking it was a trick question
February 22, 2011 at 10:28 am
I've reworded the answers to eliminate confusion and awarded back points to everyone up to this time.
Viewing 15 posts - 1 through 15 (of 23 total)
You must be logged in to reply to this topic. Login to reply