证实些学,才能真的学到东西。不过可以贴些题目大家一起讨论下:
Which of the following must occur to restore a database which has table space containers on invalid drives/devices?
Use roll forward recovery on the database
A backup image of the MYDB database exists in the directory. The following restore command was run:
RESTORE DATABASE mydb FROM INTO sample NEWLOGPATH REPLACE EXISTING
Which two of the following reflect the state of the SAMPLE database after the restore?
(Select 2)
The database manager configuration file is over-written.
The system catalog tables for the database are replaced.
The LOGPATH database configuration parameter is retained.
The database configuration file for SAMPLE is over-written.
The authentication type for the database is reset to the default
Use the REDIRECT option to restore the database
Use the RESTART DATABASE command on the database
Use the recovery history file to restore the database
最初由 samm_1999 发布
[B]我不太明白 RESTORE DATABASE mydb FROM INTO sample NEWLOGPATH REPLACE EXISTING中的 “REPLACE EXISTING”的含义 [/B]
REPLACE EXISTING
If a database with the same alias as the target database alias already exists, this parameter specifies that the restore utility is to replace the existing database with the restored database. This is useful for scripts that invoke the restore utility, because the command line processor will not prompt the user to verify deletion of an existing database. If the WITHOUT PROMPTING parameter is specified, it is not necessary to specify REPLACE EXISTING, but in this case, the operation will fail if events occur that normally require user intervention.
Command Reference 那本要看啦!