I guessed as well... setup event log is not something I'm familiar with.

Wow, great question! Thanks!

Ugh, thought this was an easy one... should have done more research first. I'd forgotten the master database doesn't allow partial restores.

It's interesting that it will still let you...

Steve Cullen (5/25/2012)

---

These sorts of questions always make me wonder if what I think I know is correct.

Why would there more than one "master"? Seems like a simple question,...

I believe the 5th and 6th parameters to xp_ReadErrorLog are start and stop datetimes respectively, so you should be able to do something like:

EXEC xp_ReadErrorLog 0, 1, Null, Null, '2012-05-16...

I'm glad everyone seems to like this question. 🙂

SQL Server's handling of trailing spaces has bitten me a couple of times. I find it somewhat counter-intuitive.

Ugh, should have gone with my first impulse, but then I thought it was a trick since you can create a foreign key type of relationship across databases with triggers.

I believe you can restore to a point in time from a full backup without a log backup, if the current log is still available and has not been truncated....