Sybase 12.4.2 Server User Manual


 
CHAPTER 11 Backup and Data Recovery
399
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.