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 charles,

    Just a though, but haven't you tried to switch to BULK_LOGGED before you run the index rebuild ? As you don't mention it, I'm wondering if there are any restriction that would prevent you going to bulk_logged (db mirroring first guess) ?

    David B.