In day-to-day operation, a database is sometimes subjected to events that pose minor problems to database structures. These events include
When to Validate a Database
You should validate a database
The command-line utility gbak can be used in conjunction with gfix to perform a sequence of validation and repair steps.
Performing a Database Validation
Database validation requires exclusive access to the database. Without exclusive access, you get the error messageOBJECT database_name IS IN USE
To validate a database, simply enter the commandgfix -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
Repairing a Corrupt Database
If you suspect you have a corrupt database, it is important to follow a proper sequence of recovery steps in order to avoid further corruption.
For a description of the gfix switches to use during this recovery procedure, refer to Table.
Firebird Related Interview Questions
|RDBMS Interview Questions||MySQL Interview Questions|
|Linux Interview Questions||Mac OS X Deployment Interview Questions|
|Windows Administration Interview Questions||Windows Server 2003 Interview Questions|
|SQL Interview Questions||NoSQL Interview Questions|
|Advanced C++ Interview Questions|
All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.