|
Data Warehouse |
|
|
[SSIS] |
|
|
Questions: |
Notes: |
|
Can you create a Differential Backup with an existing Full Backup? |
You use a differential backup along with a full backup.
If a full backup does not exist, you cannot create a Differential Backup.
As with a full backup, you can perform a differential backup of a database no matter what recovery model is specified for the database. |
|
How do you create a Differential Backup? |
|
|
What are the conditions that need to exist to create a Differential Backup? |
|
|
What is the difference between Differential and Incremental Backup? |
Incremental Backups depend on each other; they depend on the existence of previous incremental backups and their sequence.
However, the differential backup captures all the data in transactions from the last time a Full Backup was taken. |
|
What is a SQL Server Extent Map? |
To determine the extents that need to be backed up by a differential backup, SQL Server maintains an extent map.
An extent map is just another data page within the database, with each bit on the page representing an extent. When SQL Server changes an extent, it changes the corresponding bit for that extent from 0 to 1. When you perform a full backup, SQL Server resets all bits to 0. |
|
What are Event Handlers? |
An Event Handler is a flow that responds programmatically to events that occur on Package level, Container level, Task level, and Variable-Value Change level. |
|
What are some events in SSIS? |
|
