Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SQL 2005 Incremental Backup Expand / Collapse
Posted Monday, March 24, 2014 5:16 PM

Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, July 27, 2016 4:32 PM
Points: 388, Visits: 422
I have a concern. I take a backup at 8pm and differential backups at 10pm and 12am. I then plan to restore the full backup to another server followed by the differentials once they complete. When I restore the differential backup, do I have restore the full back plus the differential at 10pm and then the full backup and the differential at 12am? Or, since I restored the full backup at 8pm, just apply the differentials at 10 and 12?

Thank you
Post #1554253
Posted Tuesday, March 25, 2014 2:39 AM



Group: General Forum Members
Last Login: Saturday, December 3, 2016 5:18 AM
Points: 45,619, Visits: 44,147
You restore the full backup from 8am and the differential from 12. They're differential backups, not incremental.

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

Post #1554317
Posted Tuesday, March 25, 2014 3:38 AM


Group: General Forum Members
Last Login: Thursday, March 17, 2016 5:13 AM
Points: 2,796, Visits: 2,232
You need to restore FULL backup and latest DIFFERENTIAL backup. DIFFERENTIAL backup is cosolidated backup and capture all the pages changed since FULL backup.


"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1554331
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse