Subject | Re: [firebird-support] Database page errors |
---|---|
Author | Vlad Khorsun |
Post date | 2007-09-26T20:47:40Z |
> Can you tell what should happen if i do a backup/restore?If you able to backup and there are no logical errors in metadata
then you can restore and use it without problems
> I'm asking because i did a backup and it got up to the end without errors.Sounds much better that what gfix said ;)
>
> [root@server1 tmp]# tail backup.log
> gbak:writing constraint INTEG_293
> gbak:writing constraint XPKV3$CONTATOS
> gbak:writing constraint R_943
> gbak:writing referential constraints
> gbak:writing check constraints
> gbak:writing SQL roles
> gbak:writing SQL role: PUBLICO
> gbak:writing SQL role: SOMENTELEITURA
> gbak:writing SQL role: PSINIT4_TOOL
> gbak:closing file, committing, and finishing. 1027317760 bytes written
> Also, my users are using this database all day and nobody notedVery strange. Are you sure error messages from firebird.log are from
> anything strange.
the same database ? And generated at the same time you run gfix ?
> Is there some way to know which tables are pointerless?You may lookup it by numbers (from firebird.log messages) in
RDB$RELATIONS
Regards,
Vlad