Subject | How to validate a database without stoping the server for hours ? |
---|---|
Author | jeanluk.picard |
Post date | 2010-07-29T20:44:01Z |
Hello,
The problem is that the database is corrupted very often, so we must do once a week a validate of the database. But we face now another problem, the validate must be done in exclusive, so we must disconnect all client ... we face this problem by first stop the firebird server, make an duplicate copy the database (that take few minutes only), after restart the firebird server, and after all of this doing the validate on this duplicate database ... everything could be ok except that the database is 60 GO in size and the validate of the database cost hours and worse it's use all the memory of the server making that no more any client can connect to it or if they are connected the connection is "freezing"
Any idea how we can do ?
The problem is that the database is corrupted very often, so we must do once a week a validate of the database. But we face now another problem, the validate must be done in exclusive, so we must disconnect all client ... we face this problem by first stop the firebird server, make an duplicate copy the database (that take few minutes only), after restart the firebird server, and after all of this doing the validate on this duplicate database ... everything could be ok except that the database is 60 GO in size and the validate of the database cost hours and worse it's use all the memory of the server making that no more any client can connect to it or if they are connected the connection is "freezing"
Any idea how we can do ?