SQL Database Recovery

Most SQL databases, for example MSSQL and Oracle, are page based with predictable structures which means that not only can corruption be located, but where there are significant structural problems affecting the data that handles the relationships between tables, the individual tables can be salvaged. Whilst this is far from perfect, and will require the re-creation of SCHEMA information, it does mean that a database data recovery can be made and the information that has taken so long to accrue may be saved. Data backed up into export files can also be merged with that salvaged from the main database to give a more complete recovery, for example one Oracle data recovery required a recovery from a RAID system where the first 4GB of each disk had been erased yet it proved practicable to recovery 90% of the data from Oracle Export Files found in free space.

For more information on SQL Database Recovery talk to Altirium Ltd