Understand how to create a real world disaster recovery plan to secure you Access databases.
As regular Access users you might know the importance of effective backups, and how important it is to frequently backup your Access databases. But in some unfortunate times, you might not be able to recover your backups, or retrieve the complete backups. Or maybe you lost data in a disaster before you could even back it up! In order to deal well with these situations, you would need what is called a disaster recovery plan. And this should be no ordinary recovery plan, but a real world disaster recovery plan. Given below are the crucial steps you need to follow to create this kind of a plan for disaster recovery.
Create an Application Inventory
The very first thing that you need to do is to make a list of all that is available to you. This should basically include all the objects that make your application, and their configuration details. This should also include the location of the application, versions linked to SQL, location of backup and master files, etc. Once this inventory is ready, you then need to deploy applications on another system.
Create an All inclusive Disaster Recovery Plan
The disaster recovery plan you create should be the one that can work well in all possible kinds of disasters. Your disaster recovery plan should be able to:
- Take care of both, the onsite, as well as the off-site backups.
- Recover backups from basic human errors, or hardware failure.
- Prevent corruption of the database, and reduce bloat.
- Automate the maintenance task as well as the audits.
- Ensure that there is an existing backup, and that this plan works.
- Invest in an mdb fix tool
Ensure the General Maintenance of your database
The very basic protection of the database can be ensured by ensuring that the compact and repair commands are being given on a regular basis. This is a very basic step to ensure that the health of the database is maintained at all times. The frequency of these commands should depend on how frequently you perform changes in the databases
Perform Regular Backups
It is very common to come across situations where you are at a loss of backup because; it has been deleted, corrupted, not taken properly, etc. In these cases recovery becomes all the more complicated. The only way out of this situation is to get access to an earlier backup. It is therefore important that you keep on taking regular backups. The frequency of your backups should depend on the amount of importance you attach to your data.
Apart from taking backups, it is also important for you to ensure that the place you are storing your backups at is a safe place for these crucial backups. Many a times users opt for storing backups on another system, also called off-site backup. This ensures that if everything is destroyed, your backup might still be safe. Another option available with the users is of on-site backups, i.e. having backups where you have the Access databases.
Document the Plan
The last thing that you need to do is to ensure that everything is in place. Here you might want to document the whole plan for better understanding
Vivian Stevens is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including recover sql and excel recovery software products. For more information visit www.datanumen.com