Sybase 12.4.2 manual Restoring in the correct order, Displaying header information, 403

CHAPTER 11 Backup and Data Recovery

RENAME IQ_SYSTEM_MSG TO ’asiquser.iqmsg’

RENAME IQ_USER TO ’/dev/rdsk/c1t5d2s1’

Note You could also issue these commands with only the last RENAME clause, since only one dbspace is being restored to a new location. Listing all of the files or raw partitions, as shown here, ensures that you know exactly where each will be restored.

Displaying header information

The CATALOG ONLY option displays the header information for the database. It does not restore any data, either from the Catalog Store or the IQ Store. See “Displaying header information” for a list of the information displayed.

When you specify CATALOG ONLY you include the FROM archive_device clause, but omit the RENAME clause.

Adjusting data sources and configuration files

When you move a database, you may need to modify your data sources, configuration files, and integrated logins to reflect the new location of the database.

Restoring in the correct order

When you restore from a full backup, every block in use at the time the backup was made is written to disk. When you restore from an incremental backup, only the blocks that changed between the previous backup (or the previous full backup) and this backup are written to disk.

You must restore full and incremental backups in the correct order, with a separate RESTORE command for each backup you are restoring. RESTORE ensures that backups are restored in order, and gives the following error if it determines that the order is incorrect:

SQL Code: -1012009

SQL State: QUA09

This restore cannot immediately follow the previous restore.

403