This feature is known not to work as expected with some
types of database. Its use is deprecated: you are strongly discouraged
from using this feature. Support for it may be removed in future
versions.
This optional parameter specifies the name of a file
where any failed SQL do queries aree logged, perhaps for later recovery.
The default is no logging. The SQLRecovery-File file is always opened
written and closed for each failed SQL do query, so you can safely rotate
it at any time.
Tip
Make the file name depend on the date.
This way, all the missed accounting records per day are located in a
single file.
Here is an example of using
SQLRecoveryFile and logging all failed queries of one
day into a one file:
# Log all failed SQL queries to a log file per day
SQLRecoveryFile %L/sqlfailures-%Y-%m-%d
