Archives of the TeradataForum

Message Posted: Mon, 03 Nov 2003 @ 21:04:35 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

The rest of the manual...

"You can restore individual tables from a database-level archive with excluded tables. In the RESTORE statement, you must individually specify all the tables you want to restore, except the excluded tables. By omitting the excluded tables, you preserve the data dictionaries and table headers of the excluded tables. That way you can restore the database from the archive without altering the excluded tables."

"However, you cannot name macros, views, or stored procedures as objects in your RESTORE statement. So if create an archive with excluded tables and you want to preserve the excluded tables, you cannot recover the macros, views, or stored procedures from the archive."

There are other work arounds, one such assumes that you have backed up the excluded tables on a different archive, in which case, you do the restore of the partial archive first, then the one with the excluded tables.

Of course that assumes the excluded tables need to be restored, maybe they are just work tables, and you don't care that they will be empty after a partial-archive restore. In that case, it is important to complete the restore by issuing a BUILD command for the excluded tables, otherwise they remain locked and unusable.

In our case, we have tables that are appended daily and others that are appended weekly, the weekly tables are backed up in a full database archive on the weekend, but are excluded the other six days in the "daily" archives. If we need to restore the database, it takes both archives to complete the process, hence, no worries about the daily partial archives, since the weekly tables can be restored from the most recent "full Sunday backup" after the daily tables are restored from the most recent "daily" partial backup.

mem

	<Prev	Next>		<<First	<Prev	Next>	Last>>