Dell-EMC
E20-818 · Question #157
A customer wants to move a specific production database to an instance that is running on the Symmetrix storage array. What is the appropriate Microsoft SQL Server process that would accomplish this…
The correct answer is A. Offline the database, detach from the instance, and then reattach to the new instance. See the full explanation below for the reasoning.
Question
A customer wants to move a specific production database to an instance that is running on the Symmetrix storage array. What is the appropriate Microsoft SQL Server process that would accomplish this task?
Options
- AOffline the database, detach from the instance, and then reattach to the new instance
- BOffline the database, attach to the new instance, and then apply the Redo Logs
- CCopy the Redo Logs to the Symmetrix and apply to a new database instance
- DOnline a new database and apply the Redo Logs from the source database
How the community answered
(46 responses)- A76% (35)
- B13% (6)
- C4% (2)
- D7% (3)
Community Discussion
No community discussion yet for this question.