Identifying Netezza Backupsets

This is more a note to self than anything…

Each week we run FULL backups against our databases, and write the backup files to disk.  In the past we kept the most current backup on disk for a week, and deleted it after the backups have been saved to tape.

Then we start the cycle all over again, and write the latest backup to disk.  At most we never had more than one backup retained on disk.

To add to our vulnerability we deleted the previous week’s backup on Friday morning.  It takes about 6 hours to do the deletes… On Friday at midnight we start the next full backups. 

But we are particularly vulnerable between the DELETE and the next FULL backup.  There’s about an 18 hour period where we don’t have any backups on disk.

To mitigate that, we are going to keep 2 weeks of backups on disk.  But before we write the 3rd backup we need to delete the first (oldest) backup.

The following command will identify the 2nd oldest backupset.  Once we have the backup set, we have all the info we need to delete the directory structure of the 2nd oldest backup before running the next FULL backup.

nzbackup -history -db myDBName | grep FULL | tail -2 | head -1 | awk ‘{print $2}’

There’s nothing complicated going on here, though it looks like a lot.  To gain a better appreciation for this, just run the commands left to right to see the impact of the succeeding command in the pipeline.

Stay curious; keep learning.


Leave a Reply

You must be logged in to post a comment.

Using Gravatars in the comments - get your own and be recognized!

XHTML: These are some of the tags you can use: <a href=""> <b> <blockquote> <code> <em> <i> <strike> <strong>

popular blog ghostwriter for hire us help with my cheap curriculum vitae online custom case study writer services us popular editor website online popular phd content help best case study ghostwriters sites professional business plan ghostwriters website uk esl school essay editor sites for university popular masters admission paper help pay to get custom research paper custom essays writing website for masters best editor services esl home work writer services for mba this is stupid stuff pay for my calculus dissertation results popular college essay writers site for mba phd essay examples write me top custom essay on pokemon go should students wear school uniforms essay cheap paper editor service gb popular critical essay editing websites for phd popular personal statement proofreading websites gb popular article ghostwriting services esl curriculum vitae writer websites usa popular academic essay editor websites usa respiration lab report custom masters personal essay samples esl papers writing service best critical analysis essay writing site top definition essay editor for hire usa esl reflective essay ghostwriters sites ca best scholarship essay editor websites online cheap reflective essay writing site for masters top academic essay writer website usa best problem solving writing services for mba cheap literature review proofreading website for masters custom essay ghostwriter website for university custom cheap essay writing service for masters professional custom essay writer site for mba dissertation methodology ghostwriters for hire us music ghostwriting for hire professional admission paper writers website for phd popular custom essay ghostwriters service ca professional paper ghostwriters services cheap admission essay proofreading services us popular case study ghostwriters site uk top academic essay ghostwriting sites online top masters course work samples write my biology annotated bibliography professional rhetorical analysis essay writer for hire gb top research proposal writers website gb the achievement of desire top definition essay proofreading service for phd cheap annotated bibliography editing websites professional thesis proposal editing website usa annotated bibliography ghostwriting websites usa best paper writers sites usa esl resume ghostwriters sites au custom rhetorical analysis essay ghostwriters site au pay to get physics application letter best school essay writing sites for mba popular resume ghostwriting services for college esl dissertation results writing site analysis of birches cathedral raymond carver characters type my religious studies term paper esl movie review writing site gb critical essay ghostwriters service au write me cheap expository essay on lincoln pay to write professional reflective essay on trump pay to get custom creative essay on shakespeare academic writers sites us top creative writing ghostwriting site gb professional article ghostwriting website for school esl bibliography writers website online popular creative essay writing website cheap dissertation writers site gb themes in beowulf custom best essay writers services gb popular persuasive essay proofreading websites usa top descriptive essay ghostwriters services for college order cheap dissertation abstract online cheap personal essay writing sites uk phil knight leadership top dissertation methodology editor website for mba esl application letter editing websites for mba professional home work writing website gb pay to write best best essay on brexit popular descriptive essay writers websites au top dissertation conclusion writers site for college top blog ghostwriting services for college a raisin in the sun literary elements friendship in julius caesar top university essay writers for hire usa literature review writers site uk popular university admission essay assistance best homework writers for hire online popular presentation editor sites for university top letter editing service for masters grid analysis definition popular problem solving ghostwriter sites blog writing services us top home work editing services for university pay for my political science thesis statement rhetorical analysis writers service usa popular problem solving ghostwriting websites for phd best dissertation conclusion writers website cheap report writers website ca custom masters dissertation chapter examples esl masters essay editing sites for university cheap speech writer website for phd custom speech editor sites usa top biography proofreading website uk help with my custom college essay on lincoln dissertation results writer sites au help me write cheap custom essay on presidential elections top essay writer site online custom thesis proofreading service for phd help with biology research paper intellectual property essay popular critical thinking editor sites ca write environmental studies papers professional thesis statement ghostwriter site for mba top college essay proofreading services for phd business essay ghostwriting site professional cheap essay ghostwriting services uk popular bibliography ghostwriter site usa esl rhetorical analysis essay ghostwriters for hire for university esl dissertation introduction ghostwriter for hire au best cv writer websites for school professional definition essay writer site for mba professional book review ghostwriters service for university top expository essay ghostwriting service for school best cheap essay writer site psychology essay ghostwriters websites best phd research paper ideas siren song analysis popular scholarship essay writer site for phd custom personal statement writer site us personal writers services usa professional college essay ghostwriting for hire gb professional masters case study examples professional term paper proofreading for hire cheap course work proofreading service top application letter writing sites for masters professional thesis statement ghostwriting website for university cheap rhetorical analysis essay ghostwriting for hire for masters top academic essay writers services for phd custom dissertation results writers website for mba professional dissertation editing sites gb professional thesis proposal ghostwriters sites usa pay to do law paper blog post writers services us esl dissertation conclusion ghostwriter services gb esl creative essay writers website for school professional dissertation introduction proofreading websites gb cheap term paper writer websites for mba persuasive essay writers sites ca top article writer for hire for school homework ghostwriting for hire uk top business plan proofreading sites ca professional essay editor for hire popular dissertation hypothesis writers for hire for school creative essay ghostwriting sites gb esl report editing for hire gb popular term paper ghostwriter services usa type my best personal essay on presidential elections professional presentation writer site for university best essay ghostwriting websites for university cheap rhetorical analysis essay proofreading sites au cheap dissertation proposal ghostwriting site for school popular paper ghostwriter for hire online cheap phd essay writers service for mba pay to do zoology problem solving help with best admission paper cheap content ghostwriting sites for phd best book review ghostwriting service online write my top scholarship essay on civil war literature review writer website usa letter proofreading for hire uk popular persuasive essay writers service uk position essay example do my religious studies book review custom school essay ghostwriting website for college help with nursing term paper top dissertation introduction writers websites uk professional expository essay writers for hire gb esl critical analysis essay writer website for school popular critical analysis essay proofreading sites for masters top cheap essay ghostwriter service us popular essays writing for hire for school write me engineering essays biography writers sites esl dissertation conclusion ghostwriters services for school cheap admission paper ghostwriter services usa he katherine anne porter top descriptive essay writing websites for phd cheap college essay writer services ca esl speech writers websites usa best term paper ghostwriters for hire for school paper ghostwriter website us research paper editor websites gb behind the formaldehyde curtain questions pay for my best personal essay on lincoln top course work ghostwriter site for mba popular blog editing service for mba cheap critical essay proofreading for hire for school top resume ghostwriters site ca professional literature review writers website usa esl dissertation introduction writers websites usa custom university research paper top dissertation proposal ghostwriting websites for masters popular case study ghostwriting sites for university best analysis essay ghostwriting website usa popular mba movie review advice esl personal essay ghostwriting site for school esl definition essay ghostwriting websites usa do my medicine home work professional book review writers service for masters best literature review editing for hire for university top blog post ghostwriters services us cheap homework proofreading sites uk custom analysis essay writing sites for masters popular problem solving writers sites for college cheap dissertation conclusion writers website uk custom report writer site for mba pay to do physics dissertation introduction esl blog ghostwriting service usa top article review ghostwriter website online pay to write chemistry admission essay dissertation conclusion ghostwriter service gb professional dissertation abstract editing site for phd popular phd school essay example custom critical essay writers services us custom essays writing websites uk best speech writing site for school cheap blog writers site for university cheap business plan ghostwriters websites for mba esl college dissertation chapter sample order dissertation online university essay editing for hire us custom thesis statement proofreading websites ca top research paper editing services online professional assignment ghostwriting services uk critical essay ghostwriters service ca best thesis statement ghostwriting websites for school beloved essays film paper topics inherit the wind analysis custom assignment editing websites us professional personal statement writing website gb cheap article writers websites usa definition editing website online popular thesis proofreading site for masters write cheap application letter online esl descriptive essay ghostwriting for hire for phd best movie review ghostwriters for hire for mba cheap course work proofreading websites online custom expository essay ghostwriting sites best presentation writer service for college custom expository essay on trump top scholarship essay editor for hire for school top college essay editor site au professional persuasive essay on presidential elections expository ghostwriter for hire au esl case study ghostwriting for hire us professional dissertation conclusion writer service for mba help with professional argumentative essay on civil war top dissertation results editor site gb help writing cheap school essay on usa custom masters essay editor website for phd esl reflective essay editor site for phd write best definition essay online cheap paper proofreading service ca top admission paper editor services for university type my investments movie review dissertation chapter writing site au top phd essay writers service au help writing engineering papers esl masters essay proofreading sites uk the natural bernard malamud popular college essay editor site gb help with algebra personal statement walmart information systems division top papers editor websites for school professional school creative writing advice best thesis statement ghostwriter website online custom research paper ghostwriter website online best masters essay editing site gb write world literature dissertation proposal professional term paper editing websites for college genetic engineering research paper top admission paper ghostwriting services for university best book review editing for hire for masters buy culture business plan esl critical analysis essay ghostwriter websites gb journalism essay editing site esl analysis essay ghostwriter website online top movie review writer for hire online cheap analysis essay writers site for phd top university essay editing website us best blog post ghostwriter website esl admission paper proofreading for hire personal essay ghostwriters websites online top phd admission paper assistance cheap report ghostwriter for hire ca personal writer services gb popular masters creative writing samples pay for my cheap analysis essay on civil war write me u.s. history and government term paper professional critical essay writing services au esl personal essay ghostwriting website esl college literature review samples help with professional best essay online top presentation writers sites gb type my art & architecture dissertation methodology top phd essay writers sites for school best cover letter ghostwriting service for masters esl definition essay proofreading websites for college pay for my leadership papers write my top case study online type my mathematics business plan esl dissertation methodology writers websites cheap dissertation proposal ghostwriting for hire online esl best essay writing site gb cheap home work writing for hire for phd best dissertation editor sites for university custom literature review ghostwriter website uk charles cooley theory best case study editing site for masters cheap thesis proposal writers for hire ca professional bibliography writing for hire help with my algebra argumentative essay top blog writers site pay to write best cheap essay on shakespeare cheap admission paper editing websites esl dissertation conclusion editor for hire ca do my top custom essay on hillary history essay proofreading website tv benefits trust essays write popular best essay on usa custom definition essay editor services for college popular blog post editing websites ca popular book review ghostwriting sites for masters university writers for hire au pay for my life science dissertation results cheap dissertation hypothesis writers site for school cheap mba homework assistance custom content writers for hire for university best speech proofreading websites uk esl article ghostwriters website online top descriptive essay editor site uk order shakespeare studies speech best application letter ghostwriting sites gb best thesis proposal ghostwriter for hire au best definition essay editor sites for university top application letter editing sites for masters application letter proofreading site ca hamlets dilemma esl expository essay editor websites gb best research paper ghostwriting sites uk top dissertation ghostwriting site online popular expository essay proofreading sites online gender stereotypes tv shows professional case study editing service for school world war 1 who won remedial math proofreading website popular personal statement ghostwriter service for university cheap speech ghostwriters for hire professional dissertation chapter editing service best cover letter proofreading site for mba custom cheap essay proofreading site for masters professional academic essay writers services for masters dissertation introduction editor for hire us popular homework ghostwriting websites online popular essays ghostwriter service au professional reflective essay ghostwriter service for college popular bibliography ghostwriter services gb masters ghostwriter services marriage definition essay popular definition essay on shakespeare cv proofreading website online top critical thinking ghostwriting sites gb custom analysis essay editor website online esl dissertation'>popular term paper ghostwriting website uk top critical thinking writer website for university pay to write best best essay on usa custom term paper writer service for mba cheap course work writing websites for mba cheap mba phd essay advice custom personal essay writing sites for phd popular research proposal ghostwriters site usa pay to do chemistry dissertation proposal esl letter ghostwriter website us top dissertation conclusion ghostwriters website for college pay for my math article best curriculum vitae ghostwriters sites usa write me custom descriptive essay on brexit best school essay editor site for college top dissertation methodology proofreading website au reflective essay ghostwriters for hire online esl dissertation results editor websites for mba esl dissertation proposal editing services for mba pay to get popular curriculum vitae cheap essay writing site uk professional research paper proofreading site uk professional custom essay editing services usa top critical thinking writing website for phd popular research paper writing for hire for masters cheap proofreading for hire for mba cheap dissertation ghostwriting website us stanley streetcar named desire personal essay writing sites usa help me write top rhetorical analysis essay on shakespeare custom college scholarship essay topic academic essay proofreading site esl cv editor for hire us custom resume ghostwriting site uk best research proposal writers sites for mba custom thesis statement editing website ca cheap curriculum vitae ghostwriter website online help me write cheap content popular academic essay ghostwriter websites us popular business plan writer service ca best creative essay writing for hire gb custom descriptive essay writing for hire au help writing ancient civilizations presentation write me film studies thesis statement cheap college essay ghostwriting for hire us romeo and juliet whos to blame cheap movie review editor website for mba oedipus rex fate quotes racism on tv esl critical analysis essay ghostwriting site gb top college application letter help professional resume editing sites uk popular scholarship essay editor websites for masters professional thesis editor site gb custom best essay writer services uk top scholarship essay ghostwriter websites for school best book review editor website ca academic essay writer sites au descriptive paragraph examples medicine essay editor websites popular college essay ghostwriting site for masters cheap creative essay writing for hire usa buy government resume help with professional cover letter custom dissertation abstract ghostwriter website usa write me education dissertation hypothesis cheap article review ghostwriting websites for school custom thesis statement proofreading websites best admission essay proofreading for hire for university do my custom thesis proposal pip and biddy cheap best essay proofreading for hire martin luther and john calvin cheap scholarship essay proofreading website for phd help writing theater studies thesis statement top cheap essay writing for hire au business essay example best presentation writing sites uk cheap resume editor service for phd cheap paper ghostwriter sites cheap article writers service online esl bibliography editing sites for school top reflective essay ghostwriting site for mba popular speech proofreading website professional dissertation introduction writer for hire for masters essay writer service au do androids dream of electric sheep essay top movie review writing sites for college pay to write best bibliography online effects of overpopulation critical ghostwriters sites gb critical analysis essay on founding fathers write my papers online professional biography ghostwriter services for phd help with my custom admission essay on pokemon go esl literature review proofreading sites gb top critical analysis essay ghostwriting services uk popular rhetorical analysis essay writing website ca write my best reflective essay on hillary popular dissertation chapter writer for hire order ancient civilizations blog post cheap creative essay ghostwriter website online professional bibliography editor service us custom creative essay editor website gb top report editor sites best academic essay proofreading website for college best dissertation methodology writer sites for college professional personal essay on civil war top personal statement writers websites au write me law annotated bibliography cheap critical essay proofreading for hire for university top college essay editing services au reflective essay writing websites us