Multiple choice technology databases

Which upgrade data-movement method requires that users not be accessing the database you want to upgrade?

  1. Copy Database Wizard

  2. Detach/attach

  3. Backup/restore

  4. Manual scripting
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The detach/attach method requires exclusive access to the database because detaching removes the database from the SQL Server instance. Users cannot access the database while it's detached. Other methods like backup/restore or Copy Database Wizard can work with active databases or use different mechanisms that don't require taking the database completely offline during the entire process.

Keep practicing — related questions