YarHad (10/9/2012)
GilaMonster (10/9/2012)
Index rebuilds don't get written into the SQL Server error log. You could add a piece to your maintenance tasks to log that a rebuild was done if you like, or run a trace or set up an extended events session.Ok, so it doesn't get written into the sql server log. Nice to know
Thank you very much!!
Just to clarify, what Gail's repeated above is that the Index Rebuild WILL be written into the log file (.ldf) that's attached to the database. That's not human readable, unfortunately.
It doesn't get into the error logs for the server, however, which is where we could actually find it. 😉
Some of the .ldf writes tend to get confused as to whether or not they're actually written there so it's really just us trying to kill some old myths and make sure they don't start up again.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA