What is the difference between a full, an incremental and a point-in-time backup, and when would you need point-in-time recovery?

What the interviewer is looking for

• This question tests backup & recovery. Explains backup types, point-in-time recovery, offsite and immutable copies, and regularly tested restores against recovery targets.
• Strong answers: Full is a complete copy, incremental captures changes since the last backup, point-in-time uses logs to restore to an exact moment, needed for mistakes or corruption.
• Likely follow-up: How would you restore without losing the good data written after the mistake?

Another way it may be asked: Someone accidentally deletes a table at ten fifteen this morning. What kind of backup lets you get back to ten fourteen?

A structure to follow: Answer, explain, example, limits

1. Step 1

   Answer

   Give your direct answer in the first sentence so the interviewer knows where you are going.

2. Step 2

   Explain

   Say how it works or why you would do it that way, in plain words before jargon.

3. Step 3

   Example

   Anchor it in something you have actually done or seen, with the detail that shows hands-on experience.

4. Step 4

   Limits

   Say when your approach would not be the right one. It shows judgement.

This is guidance on shape, not a script. Use your own real experience and facts; never invent details to fill a gap. See the STAR guide and answer frameworks.

Common slips

• Reciting a definition without showing you have applied it.
• Using terms you cannot explain if asked a level deeper.
• Claiming experience beyond what you can discuss in detail.

How to practise it

Say the answer in 90 seconds, then answer the follow-up as if it were a new question.

Related questions

• Leadership asks how confident you are that we could recover from ransomware hitting our databases. How do you answer, and what would you test?
• What is an index, and why can adding too many indexes to a table actually hurt?
• A developer asks for full admin access to the production database to debug an issue. How do you respond?
• A query that used to take a second now takes a minute. Walk me through how you would figure out why.
• How does replication work in a database you know well, and what can go wrong with replica lag?

Browse all questions