Archives of the TeradataForum

Message Posted: Fri, 28 Jan 2005 @ 16:37:01 GMT

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

The reference David made was to only restore the DBC and not the actual restore of the userdbs. In order for a true re-creation of an entire instance of Teradata, you need to restore both the DBC AND all the databases (including users databases).

Note: I see a problem if you only restore the dbc and not the users in from the archive. You may have a problem with a create user statement, if the dbc thinks that user already exist. I have never tried to create a user after a restore of the DBC without a restore of the users databases as well.

This is even more critical when you perform cluster backups, because a dictionary backup has to be taken in addition to the dbc database tables, as a separate archive job because they are excluded from a cluster a backup.

Michael E. McBride
Teradata Certified Master
Teradata Database Administrator
Data Architect and Data Warehouse Practitioner
American Eagle Outfitters

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