DicksonMulwa (4/30/2015)
Will the SQL Server engine recovery process roll forward or roll backwards transaction (T1)?
If the COMMIT TRANSACTION for T1 is recorded in the log it will be rolled forward. If no COMMIT for that transaction can be found in the log, it'll be rolled back.
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