Method and system for preserving real-time access to a system in case of a disaster

A method as claimed in 1 and 2, for preserving access of a system in case of disaster having a primary filestore and a primary system database, the method comprising the steps of:

• creating a replica system having a replica filestore and a replica system database;
• periodically copying data from the primary filestore to the replica filestore;
• in response to a change to the primary filestore copying the said document stored to a secondary empty replica filestore.
• in response to a change to the primary system database, making a corresponding change to the replica system database based on the time of earliest recorded data;
• and
• in the event of data corruption of the primary system, using the changes and transaction information stored to the replica system database and second replica filestore to rollback the replica system to a point prior to the corruption.

A system for preserving access of a system in case of disaster having a primary filestore and a primary system database, comprising:

• a replica system having a replica filestore and a replica system database;
• having a second empty filestore for recording all changes to the primary filestore;
• and having at least one database trigger on each primary system table save those that uniquely identify the primary system on the network fabric for catching recording and transferring, reference data to the replica system database which has been inserted deleted and or been updated in the primary system table;
• and
• at least one access preservation table for storing access preservation data;
• and
• at least one transaction table one being placed on the replica, and primary system for storing all transactions, and reference data on the basis of earliest recorded time;
• and
• at least one database procedure to carry out asynchronously fast forward or rollback changes in the metadata and or filestore by using the transaction tables, access preservation tables and the second replica filestore and;
• at least one second replica filestore or storage media for storing individual files inserted deleted and updated on the primary filestore being supplied by the at least one database procedure.

A method for preserving access to document data within a system in a separate location, wherein said document data is stored in a system filestore associated with a system database, the system database containing reference data to point to the document data within the system filestore, in case of disaster to the primary system such as, earthquake, the secondary system can be used, the method comprising steps of:

• creating a replicated server containing the system database and filestore;
• determining that a insert, update, delete command has been issued within the primary production system database upon its system tables excepting those containing reference information that uniquely identifies the production system database from its replica on the network fabric;
• transferring and recording the commands above to the database system tables of the replica based on time of earliest recorded data;
• and
• transferring recorded document data to the replica filestore using incremental primary filestore backup restores;
• and
• transferring and recording files as inserted, deleted or updated to the second replica filestore and or to storage media.