Described is method and system for protecting file on volume based CDP and restoring data consistency between files and database managed by database application. One of the benefits of an implementation of the inventive concept is that administrator can protect a specific file by inserting a marker, which is stored on a journal volume after the close operation for a file. The data consistency between files and database is achieved even if the restore point is specified using a file attribute. One implementation includes host and storage subsystem. The storage subsystem may include multiple volumes for separately storing database tables and data files. The storage subsystem also includes a volume based CDP protecting the content of the storage volumes. The storage subsystem further includes an inventive consistency manager, which manages data consistency between the file volume(s) and the database volume(s). The consistency manager operates when storage system administrator issues command to restore sets of the volumes to a predetermined state, which was existent at specific time point.