Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2009-11-06 : 15:59:43
|
| I was asked this question in the interview: If a backup starts at 6pm and ends at 7 pm. What does the backup contains? (Changes made till 6 or changes made till 7)I gave a vague answer, but I really don’t know the answer. ------------------------I think, therefore I am - Rene Descartes |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-11-06 : 20:03:30
|
| Have you checked Books Online? The answer is in there. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-11-06 : 22:35:45
|
AHA! TRICK QUESTION! He didn't mention whether it was a full, differential, log or filegroup backup.  At least that would be my reply. You're right if it's a full database backup (I wanted Ravi to LOOK IT UP though) |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2009-11-09 : 10:20:43
|
quote:
Originally posted by robvolk
Have you checked Books Online? The answer is in there.
I checked BOL but didn’t find the answer. I am sure BOL has the answer somewhere. BOL is an ocean. Sometimes it becomes difficult to find answers in BOL for tricky questions.------------------------I think, therefore I am - Rene Descartes |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2009-11-09 : 10:50:45
|
quote:
Originally posted by X002548
All Data from 6, the the application of the transaction log until the completion of the dump
Thank you, X002548. That answers my query.------------------------I think, therefore I am - Rene Descartes |
|
|
|
|
|
|
Interview question: Backup