Database restore from full and diff

• lulu_lutz

  SSCrazy

  Points: 2155

  More actions

  June 27, 2011 at 3:03 pm

  #389846

  Once I do the full backup restore, do I have to apply each differential in order, or can I just apply the last differential from the 25th?

  6/22/11 Full backup

  6/23/11 Diff backup

  6/24/11 Diff backup

  6/25/11 Diff backup

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  June 27, 2011 at 3:09 pm

  #1344852

  Restore the full. Restore the last differential. If you have log backups restore them all in order. Restore all but the last backup WITH NORECOVERY

  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

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• muthukkumaran Kaliyamoorthy

  SSCoach

  Points: 19026

  More actions

  June 27, 2011 at 11:50 pm

  #1344959

  sqluser_8119 (6/27/2011)

  ---

  Once I do the full backup restore, do I have to apply each differential in order, or can I just apply the last differential from the 25th?

  6/22/11 Full backup

  6/23/11 Diff backup

  6/24/11 Diff backup

  6/25/11 Diff backup

  Followed by gail's reply

  Restore a full backup with norecovery on 6/22/11 +

  Restore a Differential backup with norecovery on 6/25/11

  If you have log backup restore it (with recovery ) after the Differential backup on 6/25/11 in a sequence.

  For more read the bottom of the post.

  Backup types[/url]

  Edited: For more info

  Muthukkumaran Kaliyamoorthy
  https://www.sqlserverblogforum.com/

• muthukkumaran Kaliyamoorthy

  SSCoach

  Points: 19026

  More actions

  July 6, 2011 at 3:23 am

  #1348806

  sqluser_8119 (6/27/2011)

  ---

  Once I do the full backup restore, do I have to apply each differential in order, or can I just apply the last differential from the 25th?

  6/22/11 Full backup

  6/23/11 Diff backup

  6/24/11 Diff backup

  6/25/11 Diff backup

  Have a look.

  SQL server Database backup restore Steps[/url]

  Muthukkumaran Kaliyamoorthy
  https://www.sqlserverblogforum.com/

• anil_kumar32

  Ten Centuries

  Points: 1378

  More actions

  July 6, 2011 at 6:33 am

  #1348868

  [font="Times New Roman"]

  Followed by Muthukkumaran's reply

  Restore a full backup with norecovery on 6/22/11 +

  Restore a Differential backup with recovery on 6/25/11 if you don't have log back up

  OR

  If you have log back up restore a Differential backup on 6/25/11 with norecovery.

  Be informed that you must restore all back up with no recovery except the last one.

  Regards,

  Anil

  [/font]