About disaster preparedness recommendations

The recommended disaster recovery method requires the use of existing database backups to restore the database. The database backups can be restored onto the same computer or restored onto a different computer. You would restore the database to the time of the backup. With transaction log backups, the database may be restored to the point of failure.

Database backups should be done on a regular basis. The backups should be stored on a different computer than the RAM installation. You should also have a set taken off-site as often as possible.

You should test your backups regularly by restoring the database on a test or a disaster recovery system. After the restoration you should verify that the backup was good by checking the database tables and the data.