Validate a database (Firebird)

To validate a database, simply enter the command

gfix -v

Validation will silently locate and free any unassigned pages or misallocated structures

it finds. It will report any corrupt structures but does not attempt to mend them.



To have gfix report faults but not attempt to free the spaces, include the –n[o_update]

switch:



gfix -v -n



You can have the validation ignore checksum errors by adding the –i[gnore]

switch:



gfix -v -i

Libros:

Bases de datos, grado superior

Aprende SQL en un fin de semana

Bases de datos, todo lo que hay que saber!

Sistemas gestores de bases de datos, grado superior

SQL (Manuales imprescindibles)