You are designing a database named DB1.
Changes will be deployed to DB1 every Wednesday night.
You need to recommend a strategy to deploy the changes to DB1. The strategy must meet the following
requirements:
The strategy must not disrupt backup operations.
DB1 must be online while the changes are deployed.
You must be able to undo quickly any changes made to objects.
What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.
A.
Perform a copy-only database backup before the changes are deployed. If the deployment fails, restore the
database to another server and recover the original objects from the restored database.
B.
Create a database snapshot. If the deployment fails, recover the objects from the database snapshot.
C.
Create a database snapshot. If the deployment fails, revert the database to the database snapshot.
D.
Perform a full database backup before the changes are deployed. If the deployment fails, restore the
database to another server and recover the original objects from the restored database.
Explanation:
Database Snapshots (SQL Server)