Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database restore from full and diff Expand / Collapse
Author
Message
Posted Monday, June 27, 2011 3:03 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, October 5, 2012 11:53 AM
Points: 128, Visits: 270
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
Post #1132505
Posted Monday, June 27, 2011 3:09 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 2:32 AM
Points: 40,205, Visits: 36,609
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 2008, MVP
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

Post #1132507
Posted Monday, June 27, 2011 11:50 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, October 13, 2014 7:16 AM
Points: 1,159, Visits: 4,656
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

Edited: For more info


Muthukkumaran Kaliyamoorthy

Helping SQL DBAs and Developers >>>SqlserverBlogForum
Post #1132632
Posted Wednesday, July 6, 2011 3:23 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, October 13, 2014 7:16 AM
Points: 1,159, Visits: 4,656
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


Muthukkumaran Kaliyamoorthy

Helping SQL DBAs and Developers >>>SqlserverBlogForum
Post #1137094
Posted Wednesday, July 6, 2011 6:33 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, October 19, 2014 8:19 AM
Points: 316, Visits: 148



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

Post #1137175
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse