You are designing updates to an existing Windows Presentation Foundation (WPF) application that connects to a Microsoft SQL Server 2008 database. The application updates will require updates to the database.
You have the following requirements:
Prevent data loss.
Recover the database if the database update fails.
You need to recommend a database deployment strategy.
Which two actions should you recommend? (Each correct answer presents part of the solution. Choose two.)
A.
Place the database in single-user mode before deploying the changes
B.
Specify the simple recovery model for the database.
C.
Specify the full recovery model for the database.
D.
Place the database in restricted user mode before deploying the changes.
Explanation:
Restricted user mode.