Error Recovery

Solutions to common RESTORE errors.

If an incremental restore fails early in the operation, the database is still usable (assuming it existed and was consistent before the restore).
RESTORE assumes an invalid tape device name refers to a disk file and tries to read from it.
If a full restore fails, you do not have a usable database.
If a failure occurs after a certain point in the operation, the restore program marks the database as inconsistent. In this case recovery is only possible by means of a FULL RESTORE. If you were performing a FULL RESTORE when the failure occurred, you may need to go back to the previous FULL BACKUP.

Reconnecting After You Restore

SAP Sybase IQ requires the DBF parameter and database file name to connect to a database when you use Interactive SQL and restore the database while connected to utility_db.

Including the DBF parameter:

CONNECT USING 'uid=DBA;pwd=sql;dbf=node1/users/localhost/mydb.db;
links=tcpip{host=serv1;port=1234};eng=serv1_iqdemo'

Returns:

CONNECT DATABASE mydb USER DBA IDENTIFIED BY SQL

To avoid this error, enter a START DATABASE command while connected to utility_db:

START DATABASE mydb

Use this method when connecting via Interactive SQL.