Home Forums SQL Server 2008 SQL Server 2008 Administration User DB Transaction Log fills up When Running Online Index Rebuild With SORT_IN_TEMPDB = ON RE: User DB Transaction Log fills up When Running Online Index Rebuild With SORT_IN_TEMPDB = ON

  • Hi David, Thanks for the post, I have considered switching to bulk-logged, but our business model requires us to be in full at all times. I suppose I should have mentioned that. And of course, that would require the addition of two whole lines of code to the SP, which is simply too much work for me to do. 😀 I'd much rather spend hours of time trying to figure out why something the documentation from MSFT says doesn't appear to be true.

    FYI for those who might be interested, I reposted this issue a few hours ago over on the Technet SQL Server forum to see what folks over there might say. So far, no replies. Here's the link: http://social.technet.microsoft.com/Forums/en-US/sqldatabaseengine/thread/d2f4d5c5-4d4d-4e85-a3b1-e1cff2f2ec91