You are design updates to the existent WPF application the connect to the MSSQL 2008. The application updates will require updates to the database. You have the following requirements:
Prevent data loss
Recover the database if the database update failure
You need to recommend a database deployment strategy. Which two actions should you recommend:
A.
Place the database in a single user mode before deployment
B.
Specify the full recovery mode for the database
C.
Place the database in restricted user mode before deployment
D.
Specify the simple recovery mode for the database