728x90

Question

If you want to restore a table space level backup image, the table space must exist prior to the restore operation, and the restore operation must be targeted to the same database. (This does not apply to version 9.5 or later if you are performing a RESTORE ... REBUILD operation using table space restores.)

Answer

Symptom: SQL2549N (the database was not restored because either all of the table spaces in the backup image are inaccessible, or one or more table space names in list of table space names to restore are invalid) while trying to restore a table space-level backup with redirect.

Cause: SQL2549N is returned if the table space has been dropped prior to the restore operation.

Action: Do not drop a table space if that table space is to be restored from a table space-level backup image, even if you want to change the container path. If you want to restore a table space level backup image, the table space must exist prior to the restore operation, and the restore operation must be targeted to the same database.



728x90

+ Recent posts