Great question Tom, with a couple of wee pitfalls to lead the unwary, fortunately I had remembered my wits today. Superb explanation too.

😀

+1 🙂

A great question thanks, straightforward but needing a little thought.

Also... re: explanation... what demonfox and Hugo said 😉

Hugo Kornelis (1/18/2013)

---

That's what I though as well when answering the question.

< snip very interesting explanation>

But again...

paul.knibbs (1/15/2013)

---

I think that's a scan that's...

As said many times already, a nice easy one to end the year.

Thanks, and a Happy New Year to one and all, bring on 2013!

😀

Merde! If only I'd waited a bit longer... however Steve might be on hols with the family already.

Haven't read all posts, just Hugo's first repy to Tom, which confirms my...

+1

Oof! That was a tough one, after using up my 50/50 I had to call a friend! Maybe it was a trick question.

Alas no, a nice easy one for this...

Thomas Abraham (12/16/2012)

---

Been a long time since I was this happy to get a QOTD right. It wasn't that hard, but I wasn't sure of the deductive reasoning I was...

Amen to that!

Knowing already that using sp_rename does not change its definition, and with there being no error scenario in the answers, I had to take the only possibly logical answer available....

Koen Verbeeck (12/11/2012)

---

I got it right, but only because I thought you had to link the mirror to the principal first, and then the principal to the mirror (which starts...

Jan Van der Eecken (12/4/2012)

---

Maybe I should have read the question properly? I knew you can configure the monitor server to record the status and historic information about log shipping...

As with other posters... I got this wrong because the author did not take into account CASCADE options.

If he meant for CASCADE off as default he should have stated that.

Taken...