Skip to main content
Database Administrators

Return to Question

Incorporated comment
Source Link
Paul White ♦
Paul White ♦
  • 90.3k
  • 30
  • 424
  • 663

whatWhat happen with the active transaction log when I stop the ms sql serverSQL Server? Under the stop process the all transactiontransactions will write to the db? Or will put when the db will starting... Thanks

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?

what happen with the active transaction log when I stop the ms sql server? Under the stop process the all transaction will write to the db? Or will put when the db will starting... Thanks

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?

Source Link
aandrosch
aandrosch
  • 13
  • 2

Transacton log backup

what happen with the active transaction log when I stop the ms sql server? Under the stop process the all transaction will write to the db? Or will put when the db will starting... Thanks