How does a differential backup know which extent

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How does a differential backup know which extents have changed so that it can be very quickly run?

Answer
The DCM tracks changes. The differential backup reads the extents from this structure.
Explanation
A differential backup uses the Differential Change Map to determine which extents have changed and need to be include in the backup. This greatly speeds the differential backup process.

(Continued on next question...)

Other Job Interview Questions

• You have a relatively new SQL Server 2005 and msdb is corrupt. How can you fix this database without a restore? (data loss is acceptable)
• You are performing a number of SELECT queries on one of your SQL Server 2005 Service Broker queues and you get a call that applications using the queues are running slowly. What can you do?
• True or false, Report Builder offers direct export to a Microsoft Access database as one of its supported export options?
• Which of the following is not available to you?
• Which optional SQL Server component must you install to ensure that you can create and execute maintenance plans?
• In SQL Server 2005 Analysis Services, what does the Synchronize Database Wizard allow you to do?
• In the SQL Server 2005 thesaurus XML configuration file, what is the expansion set?
• You are looking to import a large amount of data from a remote OLEDB data source that is not a text file. Which of the following techniques can you use?
• What rights does a user need to perform a truncate table command SQL Server 2005?
• Which collation is used for Service Broker messages sent between the instances?
• More...