Implement a Migration Strategy

Question 1

What are the attributes of Detatching and reattaching a database?

Answer 1

Offline
Instant, the only time is copying the database
Log file needs to be copied
Fragmentation increases size
Not Audited
Advanced options not available

Question 2

What are the attributes of Backing up and Restoring a database?

Answer 2

Online
Backup - Minutes to Hours | Restore - 3 times as long
Log files do not need to be copied
Fragmentation does not increase size
Audited
Advanced Options Available

Question 3

How can you solve the issue that logins don’t exist when you’re migrating to another server?

Answer 3

Use Contained Database
Use an SSIS Task
Copy Database Wizard
Microsoft Scripts

Question 4

What are the two different strategies for upgrading a server?

Answer 4

In Place (Drop and recreate)
Side By Side (Same or Different Server)