AW: [firebird-support] Problem Firebird 2.5
Thanks Paul, I have found the issue :) Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Gesendet: Mittwoch, 17. Februar 2016 15:38 An: firebird-support@yahoogroups.com Betreff: [firebird-support] Problem Firebird 2.5 <> Usually caused (AFAIK) by a restore done with Firebird 2.1 or an earlier gbak, or if a Firebird 2.5 backup was restored to Firebird 2.1, backed up and then restored on Firebird 2.5 On the original database you can do DROP ROLE RDB$ADMIN; COMMIT; When you restore, gbak.exe should recreate the RDB$ADMIN role. Paul
AW: [firebird-support] Problem Firebird 2.5
Oh shit, thank our so much! There was an old gbak in the system32 directory which were the task planer has make a backup. -Ursprüngliche Nachricht- Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Gesendet: Mittwoch, 17. Februar 2016 15:25 An: firebird-support@yahoogroups.com Betreff: Re: [firebird-support] Problem Firebird 2.5 17.02.2016 15:14, 'Checkmail' check_m...@satron.de [firebird-support] wrote: > .it is not the gbak from firebird 2.1 The error shows that the backup was created with gbak 2.1 but from server 2.5. Nothing you can do but create database from scratch and pump data. > Now, gfix shows me single user maintenance in attributes > > I have no access to the database You can bring the database online with gfix to pump data from it. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links
AW: [firebird-support] Problem Firebird 2.5
.it is not the gbak from firebird 2.1 and I'm using the -user sysdba -pas masterkey switches. What can I do? Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Gesendet: Mittwoch, 17. Februar 2016 14:32 An: firebird-support@yahoogroups.com Betreff: [firebird-support] Problem Firebird 2.5 Hello @ll, during a restore of a firebird gbk on a fres installed system with the same firebird 2.5 cs server like the original server, I get this error: attemp to store duplicate value (visible to active transactions) inn unique index RDB$Index_39 Problematic key value is (RDB$ROLE_NAME = RDB$ADMIN) Now, gfix shows me single user maintenance in attributes I have no access to the database, what goes wrong? Thank you