Eduardo Olivera (4/17/2014)
What if I change the databases to simple recovery mode and then reboot?
You break your log chain and sit with potentially a many hour recovery after the restart. Recovery model has nothing whatsoever to do with how a transaction rolls back.
I wasn't joking when I said there's little you can do other than wait.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability