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?
A.Leave torn page repairs offline.
B.Leave database read-only and able to restore additional transaction logs.
C.Leave database operational.No additional transaction logs can be restored.
D.Leave database non-operational, but able to restore additional transaction logs.
Answer:C
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?
A.Leave torn page repairs offline. B.Leave database read-only and able to restore additional transaction logs. C.Leave database operational.No additional transaction logs can be restored. D.Leave database non-operational, but able to restore additional transaction logs.