Database restore from full and diff

Question

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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004494 More actions · Answer 1

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 · Answer 2

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 · Answer 3

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: 1328 More actions · Answer 4

[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]