Implement a Migration Strategy Flashcards
1
Q
What are the attributes of Detatching and reattaching a database?
A
Offline Instant, the only time is copying the database Log file needs to be copied Fragmentation increases size Not Audited Advanced options not available
2
Q
What are the attributes of Backing up and Restoring a database?
A
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
3
Q
How can you solve the issue that logins don’t exist when you’re migrating to another server?
A
Use Contained Database
Use an SSIS Task
Copy Database Wizard
Microsoft Scripts
4
Q
What are the two different strategies for upgrading a server?
A
In Place (Drop and recreate) Side By Side (Same or Different Server)