Microsoft
70-450 · Question #139
You are in the process of installing SQL 2008 as a a side-by-side upgrade. You want to migrate all databases from SQL 2005 to this new instance. Which method could you use to achieve this?
The correct answer is D. Any of these options. See the full explanation below for the reasoning.
Question
You are in the process of installing SQL 2008 as a a side-by-side upgrade. You want to migrate all databases from SQL 2005 to this new instance. Which method could you use to achieve this?
Options
- ABackup the database and restore to the new SQL 2008 instance
- BUse the Copy Database Wizard to migrate databases
- CDetach the databases from the old instance and reattach to the new instance
- DAny of these options
How the community answered
(16 responses)- A19% (3)
- C6% (1)
- D75% (12)
Community Discussion
No community discussion yet for this question.