窑洞现在上不去。
我restore时出现的错误如下:
Attempt to store duplicate value (visible to active transactions)
in unique index "RDB$INDEX_2"
下面是我从帮助中摘录下来的,各位看看是否有救。
Deactivate Indices
Normally, InterBase rebuilds indices when a database is restored. If
the database contained duplicate values in a unique index when it was backed
up, restoration will fail. Duplicate values can be introduced into a database
if an index was temporarily made inactive (for example, to allow insertion of
many records or to rebalance an index). To enable restoration to succeed in
this case, set the Deactivate Indices option to True. This makes indices
inactive and prevents them from rebuilding. Then, eliminate the duplicate
index values and re-activate indices through ALTER INDEX in the ISQL tab.A
unique index cannot be activated using the ALTER INDEX statement; a unique
index must be dropped and then created again. For more information on
activating indexes, see the online SQL Reference.
Note:
The Deactivate Indices option is also useful for bringing the database
online more quickly. Data access will be slower until the indexes are rebuilt,
but at least the database is available. After the database is restored, users
can access the database while you reactivate the indexes.
大家帮帮忙,提前