jwcolby
jwcolby at colbyconsulting.com
Wed Mar 7 10:02:25 CST 2012
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>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 at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver >> http://www.databaseadvisors.com >> >> > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >