Netezza: Restore a table from an INCREMENTAL Backup

Netezza supports 2 types of backups:

  1. FULL
    • CUMULATIVE – All changes since the last FULL backup
    • DIFFERENTIAL – All changes since the last FULL or CUMMULATIVE

The first step to restore a single table is to see what backups we have.  Note: That NZ calls the FULL backup Increment #1.

Determine what incremental backups we have.  In this case we have a FULL + 1 DIFF backup.

[sourcecode language='sql'  padlinenumbers='true']
$ nzrestore -connector filesystem\
 -dir /backup1 /backup2 /backup3 \
 -sourcedb mySouceDB -incrementlist

Database      Backupset      Seq # OpType NPS Host
------------- -------------- ----- ------ ----------
mySouceDB     20150502072114 1     FULL   MYnetezza
mySouceDB     20150502072114 2     DIFF   MYnetezza

Restore a single table (to a different database) up to the latest backup:

[sourcecode language='sql' ]
$ nzrestore -db MY_TEST -connector filesystem \
-dir /backup1 /backup2 /backup3 \
-sourcedb MySouceDB -tables MyTable

Restore of increment 1 from backupset 20150502072114 to database 'MY_TEST' committed.

Restore of increment 2 from backupset 20150502072114 to database 'MY_TEST' committed.


If you want to limit the restore to the FULL (or an intermediate DIFF) add the -INCREMENT argument:

[sourcecode language='sql' ]
$ nzrestore -db MY_TEST -connector filesystem \
 -dir /backup1 /backup2 /backup3 \
-sourcedb MySourceDB \
-tables MyTable -increment 1

Restore of increment 1 from backupset 20150502072114 to database 'MY_TEST' committed.


Some general comments:

  • The above backups are for backup files saved on a disk (-connector)
  • The backups are spread across 3 drives (-dir)
  • We are restoring to a different database (-db <> –sourceDB)
  • Multiple tables can be restored by adding their names to the –tables argument, space delimited.  Table names are case sensitive.
  • If the table does not exist, it will be created.
  • If the table does exist, use the –droptables argument for for the table to drop before the restore starts.

I’m sure I will reference this the next time I need to restore a table…

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>

top article ghostwriter service for phd custom admission paper writers services usa custom college term paper examples cheap curriculum vitae editing services for phd help me write english biography professional report editor for hire for mba best essays ghostwriters websites usa esl definition essay editor services uk pay for my top dissertation conclusion online order philosophy dissertation proposal characterization of gatsby top annotated bibliography editing sites ca professional thesis writer sites ca cheap blog post editing services best letter writer websites for university esl dissertation results writing for hire uk cheap business plan editor service usa esl admission paper writers websites online professional definition essay editing sites au help me write law dissertation conclusion esl resume editor site for university esl papers editing site for university cheap report ghostwriting website for university esl mba essay editing site usa esl report ghostwriter websites for mba esl thesis writer services for phd cheap dissertation abstract writing website us top admission paper editing for hire for university custom essay writer site for college help with cheap definition essay online custom course work editing website pay for my political science thesis proposal cheap research paper editing services ca cheap cover letter ghostwriting website au esl college article topic professional rhetorical analysis essay writer for hire gb professional thesis statement writer site best cv editing services for college hcl plus caco3 custom resume ghostwriting sites ca pay for my professional thesis statement popular academic essay editor sites au esl problem solving writing site usa professional thesis editing site for mba cheap article ghostwriters for hire for college popular custom essay editing website for masters esl academic essay writers services for university argumentative essay writers websites uk top letter ghostwriter services us popular college essay ghostwriters website usa professional admission paper writer website uk pay for custom persuasive essay on hillary cheap school dissertation results example esl argumentative essay writing websites for school phd essay editing websites usa professional term paper proofreading sites au cheap school biography topics best dissertation abstract ghostwriter for hire online top essay writer for hire for phd custom report editing sites us best course work writing websites for phd top school essay writing website online custom university case study sample esl thesis ghostwriting websites ca type my popular business plan professional mba essay editor websites usa metaphors in beowulf definition essay proofreading service online personal essay ghostwriters sites au help me write theater studies thesis cheap blog editor website online write astronomy speech business plan proofreading site au popular mba essay writer for hire gb help writing social studies critical thinking cheap papers writing sites for school cheap creative essay ghostwriter services usa professional definition essay ghostwriter site uk cheap admission essay writer services online professional critical analysis essay ghostwriter for hire for college cheap application letter ghostwriters website uk write my mathematics creative writing top dissertation abstract editor for hire uk buy chemistry blog post descriptive essay ghostwriters site usa pay for anthropology blog post best phd movie review examples cheap problem solving ghostwriting for hire for school astronomy proofreading sites cheap admission essay writers services us cheap dissertation methodology writing website usa professional resume editor sites for school esl admission essay ghostwriting sites ca bullying cause and effect essay popular research paper proofreading sites for mba pay to write u.s. history and government course work top dissertation abstract ghostwriters site for university custom research proposal editing service au custom biography writing sites for masters custom problem solving ghostwriter service for school custom mba dissertation methodology help pay to get best best essay custom annotated bibliography ghostwriters service us custom dissertation abstract ghostwriters sites au custom expository essay writers services uk top university essay ghostwriter service gb help with film studies assignment top resume editing site for college order esl critical analysis essay online top university essay writers sites for university esl reflective essay writer sites for masters custom speech writers websites ca custom content editing site for school popular argumentative essay writer site online popular papers ghostwriter site au top dissertation hypothesis writers sites for phd popular article writers websites for mba best personal essay ghostwriter websites for mba problem solving ghostwriter for hire ca top dissertation hypothesis proofreading for hire for phd esl research proposal writing websites us top book review writers for hire gb popular argumentative essay editor services online thesis proposal editing services best custom essay proofreading sites for college life science essay assistance esl movie review editor service for phd do my popular masters essay on hacking esl descriptive essay ghostwriter service for masters popular assignment writers for hire popular homework ghostwriters services uk top critical essay writing site custom definition essay writing services for phd cheap paper ghostwriters sites for college pay to do composition case study type my cheap papers online from my bondage and my freedom summary top research paper ghostwriter websites ca cheap personal essay ghostwriter sites us custom masters essay ghostwriting site for phd killer angels characters do my life science case study top book review editor site online popular ghostwriters service for university help with popular research proposal online cheap creative writing ghostwriting websites for college popular college essay proofreading service for phd top expository essay ghostwriting for hire for mba application letter ghostwriters service online diversity essay ideas custom literature review writing services gb help writing ancient civilizations presentation order world literature essays best problem solving editor sites for mba popular biography editor site for phd esl dissertation abstract writing site ca custom masters curriculum vitae example scholarship essay writing sites uk herbert gans urban villagers cheap dissertation abstract writing sites for school esl course work writing services ca esl dissertation chapter ghostwriter services for university socialism vs liberalism custom cover letter editing website for college professional dissertation conclusion writer services gb help me write culture dissertation conclusion top critical analysis essay writer service usa research paper writer service top research proposal writers for hire au popular masters essay proofreading site for masters custom custom essay ghostwriter website uk pay to get remedial math presentation best thesis writer for hire ca papers proofreading websites uk professional blog editing sites uk popular thesis proposal proofreading sites romanticism and realism buy human resource management paper cheap creative essay proofreading website for phd pay to do top rhetorical analysis essay on hacking esl problem solving editor service for college best dissertation results ghostwriters sites us custom term paper ghostwriting websites online esl school essay writer sites usa buy esl essays esl course work editing website for phd leadership ghostwriting sites psychology writers website best dissertation results ghostwriter services for phd popular movie review editing site uk annotated bibliography writers website usa cheap descriptive essay ghostwriting for hire ca help with custom college essay on founding fathers pay to do sociology problem solving write my papers online order professional college essay custom letter ghostwriters for hire au cheap university term paper examples top definition essay proofreading website for school write top best essay on donald trump popular critical essay editing for hire online best dissertation methodology writer sites for masters popular argumentative essay on presidential elections type my political science dissertation introduction synthesis essay examples personal essay ghostwriting for hire au popular research proposal writers for hire for masters popular critical thinking ghostwriter sites for college top biography editing site uk help with my sociology annotated bibliography best school school essay example cheap best essay proofreading for hire professional problem solving ghostwriters sites uk custom analysis essay proofreading sites esl dissertation methodology ghostwriting websites for mba professional critical thinking editor site au best blog ghostwriter websites for school how do accountants use math popular school essay ghostwriters service uk custom college essays examples help with custom scholarship essay on civil war custom content editing services for school pay for my best blog online cheap essays ghostwriters website for college pay for my esl persuasive essay on shakespeare esl masters bibliography ideas help with my shakespeare studies dissertation introduction scholarship essay editing websites au cheap report ghostwriting services alcoholism in russia invisible man symbols cheap critical analysis essay writer sites for phd custom content writer websites for phd popular university essay ghostwriters sites for mba esl article review writing websites usa popular definition essay writing sites us harry potter monomyth top cv editing website for mba thesis proposal ghostwriting service gb professional literature review ghostwriter sites gb content ghostwriting site au best homework proofreading website for school calculus essay writer sites popular mba essay ghostwriters services esl school dissertation introduction samples custom essays editor website for phd esl college essay editing site online esl thesis statement writing websites au custom literature review ghostwriting services uk type my custom admission paper best school essay editing site online help with my critical essay on founding fathers top school essay writer services au help with best university essay on usa popular course work ghostwriting for hire usa professional course work writers website us cheap letter ghostwriting sites uk casting director job description professional cheap essay editing services au help writing top rhetorical analysis essay on hillary esl article review writers for hire for mba esl definition essay editor website uk top creative essay writers services au custom cheap essay writing service for masters best college analysis essay topic custom analysis essay ghostwriting for hire usa help writing top reflective essay on hacking dill character traits popular best essay proofreading services for masters best rhetorical analysis essay writing for hire for university write popular argumentative essay on hillary best problem solving writing site for phd popular thesis statement writing services for school esl creative essay writers for hire for university esl argumentative essay editing service for school help writing drama dissertation chapter best problem solving ghostwriters service usa best descriptive essay ghostwriters service for phd cheap thesis statement ghostwriters website for university filling station elizabeth bishop analysis killing mr griffin sparknotes professional critical essay ghostwriter websites gb professional blog editor service for school popular scholarship essay ghostwriter for hire au cheap college essay writing websites au cheap letter writers sites for university popular application letter proofreading services gb popular school essay writer websites uk pay to get journalism cover letter best letter writer site for mba cheap scholarship essay ghostwriting websites for college custom dissertation results writer services usa professional dissertation methodology proofreading website for school order reflective essay on hillary top best essay writing websites online personal essay on education write me mathematics dissertation proposal pay to do esl academic essay on lincoln popular research paper editing website for masters esl literature review proofreading service for mba popular critical analysis essay ghostwriter site uk popular dissertation chapter ghostwriters services us best scholarship essay ghostwriters sites for mba professional papers writing site for college popular dissertation methodology writer site us esl university definition essay ideas cheap creative essay on usa best school essay examples popular reflective essay ghostwriters sites for university help with my environmental studies case study esl letter ghostwriters website us women before ww1 definition essay writing site custom essay writing services for college elvis presley women best business plan proofreading site for phd best writing site for university best thesis statement writing services ca top admission paper writer site for masters professional masters essay proofreading websites uk cheap cv ghostwriter services for mba buy best essay on brexit top dissertation hypothesis ghostwriter services for school top article review ghostwriters services ca cheap essay ghostwriters websites gb earth science writing website pay to get custom paper online help with my science thesis academic essay on math expository essay ghostwriter sites uk top argumentative essay editor websites usa best homework writing services for school help with my popular college essay on donald trump cheap biography editing services for mba john donne loves alchemy cheap admission essay writers websites for university popular critical thinking writing services ca esl assignment editing service for college popular personal statement editing website online top expository essay writing sites ca custom research proposal ghostwriter services for mba esl thesis statement ghostwriters site gb write cheap argumentative essay on pokemon go esl masters academic essay example richard rodriguez aria analysis write professional expository essay on donald trump popular biography editing services uk top admission essay writers site for university popular research proposal ghostwriter site for phd best best essay writer services gb pay for my health course work pay to get cheap university essay professional analysis essay editor services gb help with math cv top mba movie review assistance esl dissertation writing service for phd cheap descriptive essay ghostwriters sites for college top phd dissertation conclusion samples custom phd essay writers sites gb esl paper writing website for college cheap problem solving writer websites usa best dissertation hypothesis ghostwriting website for phd best argumentative essay editor site us top dissertation results writers website for university cheap mba essay ghostwriting site au top best essay editing website us best cheap essay proofreading website for phd help with esl scholarship essay on hacking esl scholarship essay ghostwriting site for mba cheap analysis essay editing for hire for school persuasive editing websites usa professional proofreading websites for university esl article review ghostwriting website us cheap persuasive essay proofreading websites for masters examples of academic strengths and weaknesses for students top article ghostwriting sites for phd professional admission essay ghostwriters service for university pay to do top rhetorical analysis essay on lincoln popular annotated bibliography proofreading sites for school type my custom definition essay on hacking popular letter writing site gb top scholarship essay writers sites online professional critical essay proofreading website us popular cv ghostwriter services for school custom phd business plan ideas popular presentation writing for hire for mba esl personal statement editing websites for school nursing essay writer service professional custom essay ghostwriters service gb popular blog proofreading websites for phd write my drama book review best academic essay writers website for university divorce cause and effect essay custom paper writing for hire gb order social studies content professional research paper editing website for college pay to get problem solving professional reflective essay writing services for mba pay to do technology application letter best literature review ghostwriters for hire usa esl college essay cheap dissertation methodology writing sites for school help me write education book review top assignment editor services uk professional blog post writer website for university popular analysis essay ghostwriters website us cheap expository essay ghostwriters service uk professional cheap essay ghostwriting service for university top dissertation proposal proofreading sites for university cheap thesis proposal writer websites braveheart last scene popular critical thinking proofreading service au custom admission paper writers services usa pay to get chemistry annotated bibliography custom admission essay writer site for mba esl masters essay writing website online cheap admission essay ghostwriter service for university popular content editing websites for school pay to get cheap critical essay on donald trump cheap thesis statement ghostwriting site for college best home work writers service for mba esl cheap essay ghostwriters service for phd best dissertation abstract writer sites uk popular mba personal statement samples best book review ghostwriting services gb write environmental studies papers custom mba essay ghostwriter for hire ca help with popular rhetorical analysis essay on pokemon go cheap business plan editor service us esl persuasive essay writer service for phd custom school essay ghostwriting site for phd professional dissertation introduction writer services au esl critical essay ghostwriters site us top dissertation abstract editor services online popular masters essay editing services us top letter editor services us expository essay ghostwriters websites online type my education homework popular descriptive essay editing website online esl college essay editing service online custom creative essay writer service esl scholarship essay editor services for mba professional annotated bibliography editing websites for phd cheap content writers services for university best article ghostwriting website for college cheap thesis statement proofreading for hire online custom school essay editing service for masters best homework proofreading sites ca persuasive essay on remedial math custom admission essay editing sites for university popular thesis proposal writers websites gb popular dissertation conclusion ghostwriters sites for university type my poetry personal statement esl dissertation hypothesis writer for hire au pay for geography dissertation introduction jane austen clueless cheap mba essay writing site uk cheap movie review proofreading for hire uk top dissertation results editor sites uk cheap argumentative essay editing sites us professional blog proofreading website for college help with custom college essay on founding fathers buy u.s. history and government course work professional thesis statement editing service for college esl presentation writer site gb esl creative writing writer website for masters pay to get best university essay on presidential elections custom best essay ghostwriting service gb statistics essay writing websites cheap article proofreading services for masters best dissertation abstract editing service for university cheap biography writers sites for college write my best best essay on lincoln professional personal essay proofreading service for phd custom persuasive essay proofreading websites for college help me write esl cheap essay on pokemon go esl definition essay writer site for school human rights essay examples popular dissertation methodology ghostwriting for hire au help with my shakespeare studies admission paper professional presentation writing services for mba help writing cheap persuasive essay on shakespeare top scholarship essay writer sites for masters custom dissertation abstract ghostwriting website au the chrysanthemums by john steinbeck summary custom letter writers website uk popular home work ghostwriter for hire for mba professional resume writers services for phd pay to write nursing research proposal cheap masters dissertation hypothesis help executive information system example custom dissertation results ghostwriters websites uk custom rhetorical analysis essay editor site for university best phd phd essay samples custom dissertation methodology writers sites for school help with my best critical thinking online write my popular college essay on hillary buy ancient civilizations personal statement professional university essay ghostwriters service for mba help me write top custom essay on presidential elections