ccmdb restore backup_file [/t|/to database_path]
[/s|/server server_name] [/o|/overwrite]
[/url server_url]
ccmdb restore backup_file [/show]
Use the ccmdb restore command to restore the database from the backup file that the ccmdb backup command created.
You must run this command on the database server, as user the CM Administrator. The destination directory must be writable by the CM Administrator.
$ ccmdb restore \vol\tools4\ccmdb\base72.sbk /t \vol\tools4\ccmdb\base721
Restore database to server 'bxz01prod'
Restoring Database \vol\tools4\ccmdb\base721 from \vol\tools4\ccmdb\base72.sbk
Extracting data from \vol\tools4\ccmdb\base72.sbk...
Loading database...
Loading database \vol\tools4\ccmdb\base721\db from standard in.
set lock mode to wait
loading IBM Rational Synergy dump file version 7.2 platform Windows ...
loading table attrib...
.1379 records.
loading table bind...
130 records.
loading table bsite...
130 records.
loading table compver...
169 records.
loading table control...
0 records.
loading table relate...
39 records.
loading table release...
1 records.
loading table acckeys...
34 records.
Updating statistics ...
Creating indexes...
\vol\tools4\ccmdb\base721\db is un-protected.
Database \vol\tools4\ccmdb\base721\db restored from file \vol\tools4\ccmdb\base72.sbk
$ ccmdb restore \vol\tools4\ccmdb\base72.sbk /overwrite
Restore database to '\vol\tools4\ccmdb\base72'
\vol\tools4\ccmdb\base72 already exists, will be deleted.
Restore database to server 'bxz01prod'
Dropping database \\bxz01prod/base72 ...
\\bxz01prod/base72 dropped!
Restoring Database \vol\tools4\ccmdb\base72 from \vol\tools4\ccmdb\base72.sbk
Clean up '\vol\tools4\ccmdb\base72'....
Extracting data from \vol\tools4\ccmdb\base72.sbk...
Loading database...
Loading database \vol\tools4\ccmdb\base72\db from standard in.
set lock mode to wait
loading IBM Rational Synergy dump file version 7.2 platform Windows ...
loading table attrib...
.1379 records.
loading table bind...
130 records.
loading table bsite...
130 records.
loading table compver...
169 records.
loading table control...
0 records.
loading table relate...
39 records.
loading table release...
1 records.
loading table acckeys...
34 records.
Updating statistics ...
Creating indexes...
\vol\tools4\ccmdb\base72\db is un-protected.
Database \vol\tools4\ccmdb\base72\db restored from file \vol\tools4\ccmdb\base72.sbk
$ ccmdb restore /show \vol\tools4\ccmdb\base72.sbk
Version: 7.2
Platform: windows
Database: informix
Server: bxz01prod
Hostname: bxz01
Database Path: \vol\tools4\ccmdb\base72
No Files: No
Format: platform_independent