• SQL Server Quiz
  • The SQL server that you've manages crashed. The disk drives w...

The SQL server that you've manages crashed. The disk drives were not damaged but there was data that had not been written to some databases. Which transactions will be rolled forward in each database when his SQL server starts the automatic recovery proce

sql-server

  1. All committed transactions that are in the transaction log

  2. All uncommitted transactions that are in the transaction log

  3. All committed transactions that are in the transaction log between the last checkpoint and the failure

  4. All committed transactions that are in the transaction log between the last two checkpoints

Show answer
Correct Option: C

Find more quizzes: