I did small test on restore.
I was trying to do the restore of the database which name already exist on the server and that DB has the same content .
when I did the restore with same name it throws the error and Netezza did not allow the restore.So when you want to restore the database on Netezza ,just make sure the DB name should not have conflict.
nz@Netezza_Server:/backup1/Netezza/NZ81258-H1/Netezza_DB> /nz/kit/bin/nzrestore -db Netezza_DB -dir /backup1 -lockdb true -backupset 20180522000016 -npshost NZ81258-H1
Error: Creation of database failed: Netezza_DB, SQL Error: 'ERROR: CREATE DATABASE: object Netezza_DB already exists as a DATABASE.'.
before doing the full restore of exiting database,we need to drop or rename the database and apply the restore,NZrestore cant override the restore of database.
I was trying to do the restore of the database which name already exist on the server and that DB has the same content .
when I did the restore with same name it throws the error and Netezza did not allow the restore.So when you want to restore the database on Netezza ,just make sure the DB name should not have conflict.
nz@Netezza_Server:/backup1/Netezza/NZ81258-H1/Netezza_DB> /nz/kit/bin/nzrestore -db Netezza_DB -dir /backup1 -lockdb true -backupset 20180522000016 -npshost NZ81258-H1
Error: Creation of database failed: Netezza_DB, SQL Error: 'ERROR: CREATE DATABASE: object Netezza_DB already exists as a DATABASE.'.
before doing the full restore of exiting database,we need to drop or rename the database and apply the restore,NZrestore cant override the restore of database.
No comments:
Post a Comment