June 25, 2009 at 9:16 am
Hello..This is for my information..Its an interview question.
Assume that you have taken full backup yesterday and taken the differential backup today. again when you take the differential backup next time, will it be holding the changes occured after last differential back up or full backup?
--Jus
June 25, 2009 at 9:33 am
Differential backup if the changes from the most recent full backup and not the last diff backup.
So you restore the latest full backup and the recent diff backup... correct me if i am wrong..
Maninder
www.dbanation.com
June 25, 2009 at 9:39 am
Thats correct.
June 25, 2009 at 9:42 am
No. my question was......If you take the differential back up second time after the full backup, will it (second differential backup file) be holding the data changed after the first differential backup or after the full backup?
June 25, 2009 at 9:48 am
Thought that was the question answered. It will take have (2nd file) all the data since the last full backup.
June 25, 2009 at 10:03 am
Jus (6/25/2009)
No. my question was......If you take the differential back up second time after the full backup, will it (second differential backup file) be holding the data changed after the first differential backup or after the full backup?
Mani answered that question:
Differential backup if the changes from the most recent full backup and not the last diff backup.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 25, 2009 at 10:20 am
Jus (6/25/2009)
No. my question was......If you take the differential back up second time after the full backup, will it (second differential backup file) be holding the data changed after the first differential backup or after the full backup?
Yes.
To both.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply