Francisco Tapia
fhtapia at gmail.com
Wed Mar 7 12:52:30 CST 2012
Its full backup latest diff and each log backup since the last diff backup. So if you have 15 log backups a day, 15 you need to restore. On Mar 7, 2012 8:04 AM, "jwcolby" <jwcolby at colbyconsulting.com> wrote: > I do mean differential. > > So the differential is everything between the full and the time the > differential is made? That would make things easier. > > How does the log file backups play into the restore sequence? Full, the > latest diff, then latest log? > > John W. Colby > Colby Consulting > > Reality is what refuses to go away > when you do not believe in it > > On 3/7/2012 9:47 AM, Francisco Tapia wrote: > >> Stuart, >> if he's stating incremental but means differential (as what sql server >> provides) then you don't need every differential, just the last >> differential backup. >> >> In my environment the backup strategy that I setup I have this scenario, >> we >> have a few 2 tb databases running around, their too big to backup nightly >> so we do a monthly weekend full backup, followed by daily diff's until the >> end of the month. We also have 60% of log backup triggers setup so that >> we >> have a re-occuring automatic log backup, to prevent log file fill ups. >> This method has worked really well for us, and minimizes the number of log >> backups that we need to deal with throughout the day when we test our >> restores (yes we test, no use running a backup that you never test). >> >> >> Our test restore databases to our development server where we have our >> greenest dba push out a restore sequence. Yes we have scripts that do >> that, but they are suppose to know the process, so they run through at >> least one manual restore process every quarter, and at least 3 scripted >> restores throughout the month. This has ensured that they can always >> restore us no matter who is on shift. >> >> >> >> -Francisco >> http://bit.ly/sqlthis | Tsql and More... >> <http://db.tt/JeXURAx> >> >> >> >> >> On Sat, Feb 25, 2012 at 13:58, Stuart McLachlan<stuart at lexacorp.com.**pg<stuart at lexacorp.com.pg> >> >wrote: >> >> On 25 Feb 2012 at 11:46, jwcolby wrote: >>> >>> How does an incremental database backup work? I kinda have a picture in >>>> >>> my head, only the changed >>> >>>> stuff is backed up, >>>> >>> >>> Correct, >>> >>> to the same file (maybe?) and so forth. Not even sure if that is true. >>>> >>> >>> Normally to separate files >>> >>> What about restores from? Is the entire thing restored? Only changes >>>> >>> from a specific date / time? >>> >>>> >>>> >>> You have to restore the last full backup AND THEN every subsequent >>> incremental backup in >>> order. >>> >>> >>> ______________________________**_________________ >>> dba-SQLServer mailing list >>> dba-SQLServer@**databaseadvisors.com<dba-SQLServer at databaseadvisors.com> >>> http://databaseadvisors.com/**mailman/listinfo/dba-sqlserver<http://databaseadvisors.com/mailman/listinfo/dba-sqlserver> >>> http://www.databaseadvisors.**com <http://www.databaseadvisors.com> >>> >>> >>> ______________________________**_________________ >> dba-SQLServer mailing list >> dba-SQLServer@**databaseadvisors.com <dba-SQLServer at databaseadvisors.com> >> http://databaseadvisors.com/**mailman/listinfo/dba-sqlserver<http://databaseadvisors.com/mailman/listinfo/dba-sqlserver> >> http://www.databaseadvisors.**com <http://www.databaseadvisors.com> >> >> >> > ______________________________**_________________ > dba-SQLServer mailing list > dba-SQLServer@**databaseadvisors.com <dba-SQLServer at databaseadvisors.com> > http://databaseadvisors.com/**mailman/listinfo/dba-sqlserver<http://databaseadvisors.com/mailman/listinfo/dba-sqlserver> > http://www.databaseadvisors.**com <http://www.databaseadvisors.com> > >