Skip to main content
2 of 2
Incorporated comment
Paul White
  • 90.3k
  • 30
  • 424
  • 663

Transacton log backup

What happen with the active transaction log when I stop SQL Server? Under the stop process all transactions will write to the db? Or will put when the db will starting...

Is it possible when I stop the SQL Server that not all transactions will be written into the db? Uncommitted transaction will stay in the transaction log and / or transaction log backup only?