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
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly