If your installation uses the cache dbspace for direct-attached
storage, follow best practices to avoid errors during backup.
- The cache dbspace must be online. An offline cache dbspace causes the backup to fail
with error 1012034. For
example:
Msg 21, Level 14, State 0:
SQL Anywhere Error -1012034: IQ store dbspace or dbfile IQDAS1 is unavailable. Backup will not be done.
(dblib/db_backupID.cxx 859)
- The cache dbspace must be read-write. A read-only cache dbspace causes the backup to
fail with error 1012058. For example:
Msg 21, Level 14, State 0:
SQL Anywhere Error -1012058: IQ cache dbspace IQDAS1 is read-only. Backup will not be done.
(dblib/db_backupID.cxx 863)
- Backing up individual cache dbspace dbfiles results in an error.
SAP Sybase IQ can reconstruct the cache
dbspace, provided it sees a raw device, or a file of the correct length at the time
the database starts. Before backing up, record the sizes of the files used to hold
the cache dbspaces.
- Changing the path of a cache dbspace dbfile on a secondary node using
the RENAME clause results in an error.