I'm assuming this isn't a growth issue in msdb and new history notifications are being logged.

My guess is someone cleaned it out. The default trace is probably too old for...

I like Grant's advice. Note that if you have enterprise edition, I might use a Database Snapshot instead of a backup for a quick rollback if that is possible.

Note that...

closing this as complete.

Closing this one as complete.

Excellent discussion, Wayne. This is one that I will keep bookmarked.

Closed as this one is complete.

Thanks, Andy, right back at you.

I hope this year is better, but last year was pretty great. Happy New Year, everyone.

Yep, I'll try to go back and lock up those that are accepted/published.

Thanks, Peter, I'll check those out.

Congratulations, you two.

Monte, and Rob, I'll get prizes going today. Can both of you PM me a snail mail address?

Steve

Best of luck on your goals, and hope they work out for you. I haven't set mine, trying to stop and think about what I want to accomplish, and setting...

CPU power has increased, but a great talk from Dr. David Dewitt in 2009 at the PASS Summit showed that disk xfer rates have not. The capacity has, but the...

Hope everyone had a good evening last night, welcome to 2011, and best wishes.

Solomon Rutzky (12/31/2010)

Now, Steve mentioned "Regardless of what columns are in the nonclustered index, the clustering key is there" which is not always true. It is most often true, but...