You are configuring a SQL Server database restore job. You want the restore operation to roll back any uncommitted transactions. Which Recovery Completion State option should you use?
Select an option, then click Submit answer.
-
○
Leave torn page repairs offline.
-
○
Leave database read-only and able to restore additional transaction logs.
-
○
Leave database operational. No additional transaction logs can be restored.
-
○
Leave database non-operational, but able to restore additional transaction logs.