Nice and simple. Thanks.

I liked this question, I happen to get it right because thinking of .Net is case sensitive and MS typically uses Proper Casing. What wonderous things you can do in...

Grant is exactly correct. You could also go with the fact that an update actually consists of a delete then an insert.

Gila,

Granted, I was using the statement 'in mirroring..' as this is the situation and you can't have mirroring without the database in Full Recovery. Guess I could have worded...

In mirroring the log cannot be reused until a log backup occurs.

My suggestion is that if the log is growing to large between your log backup job executions then...

I don't understand how it can be 'all of the above' when answers 3 and 4 are in direct opposition.

I don't care for the wording in this question. We have a lot of replication in our enviroment. The question says 'adding a publication' where when you add a publication...

Nice, tried to get a little tricky with that third option. Good question.

Nice easy question after a day full of issue, bugs and headaches. Thanks.

I happened to have been researching this just a few months ago since we have started to go with compressed backups for the servers that support it. Nice question.

This is really good to know. I will keep this in mind.

Hope that everyone's 2012 starts out safe and exciting. Looking forward to a wonderful year of mind bending questions.

[font="Times New Roman"]HAPPY NEW YEAR!![/font]

If you watch christmas specials the majority do not include Rudolf. Typically only specials specifically refering to Rudolf have 9 reindeer. Nice question though.

Nice question, almost fooled me with the answer of 32 there which is simply nested triggers not triggers per table.

Nice question. I actually got it wrong becuase I read it wrong. Today is certainly going to be one of those days.