Sybase 12.4.2 manual Restore statement, Restoring from a compatible backup, 399

CHAPTER 11 Backup and Data Recovery

Database has changed since the last restore

Note Adaptive Server IQ does not let you do an incremental restore if the database has changed since the previous restore. However, it does not prevent users from making changes. It is the responsibility of the DBA or system operator to ensure that no changes are made to the database until all restores are complete.

Restoring from a compatible backup

RESTORE lets you restore database files for Adaptive Server IQ 12.0 and up. Due to changes in the format of the database, Adaptive Server IQ 12.0 does not let you restore from a backup created on an older version. Likewise, you cannot restore a pre-Version 12.0 IQ database from a Version 12.0 backup.

To move your data from an Adaptive Server IQ 11.5.1 database to Adaptive

Server IQ 12.0, you must follow the migration procedure described in the

Adaptive Server IQ Installation and Configuration Guide.

RESTORE does not let you restore an Adaptive Server IQ backup to an

Adaptive Server Anywhere database.

The RESTORE statement

To restore a database, use the following syntax:

RESTORE DATABASE ’db_file’

FROM ’archive_device’ [ FROM ’archive_device’ ]...

... [ RENAME dbspace_name TO ’new_dbspace_path’ ]...

... [ CATALOG ONLY ]

Remember that you must be connected to the utility_db database as DBA to issue this statement.

You must specify the db_file and at least one archive_device.

For db_file you specify the location of the Catalog Store file for the database (created with the suffix .db by default). You can specify the full pathname or a pathname relative to the server where the database was created. If you specify a new pathname, the Catalog Store and any files created relative to it will be moved to that location, except for any files you include in a RENAME clause.

399