The RESTORE... CATALOG ONLY option reads only the backup header from the archive, and writes the results to the backup log in the same format as the log entry. RESTORE... CATALOG ONLY does not restore any data, either from the catalog store or the IQ store.
RESTORE DATABASE 'database-name' FROM 'archive_device' CATALOG ONLYThis example reads the iqdemo archive:
RESTORE DATABASE 'iqdemo.db' FROM '/disk1/users/jones/backup/iqdemo' CATALOG ONLYand writes this result to the backup log:
RESTORE, -1988637423.0, bigendian_420111.db, ASIQ, '2013-01-11 06:57:00.000', DBA, Full, Arch, bigendian_420111_backup, '' BACKUP, 453495113.0, iqdemo.db, ASIQ, '2013-01-23 10:33:00.000', DBA, Full, Arch, /disk1/users/jones/backupiqdemo, '' RESTORE, 453496081.0, , ASIQ , '2013-01-23 10:33:00.000', DBA, Full, Arch, /disk1/users/jones/backup/iqdemo, ''