Backup strategies center on your business requirements for protecting your data. Database backup strategies vary according to business requirements and the database environment, such as production, development, or QA.

For example, for a production database with a high transaction volume and business rules that require the highest possible database resiliency, you might define the following backups:

Take full external backups twice a day.

Take database snapshots every hour.

Enable point-in-time recovery to keep a continuous log of all transactions as they occur on the running database.

Retain your full backups for a month or more.

If your business rules state that you must preserve every transaction, you can specify that the database must shut down if the point-in-time recovery's write-ahead log runs out of space. For a development database where data loss is not a concern, you might take full external backups every week with daily snapshot backups and point-in-time recovery disabled.

You can initiate backups manually (one-time backups) or automatically (recurring backups). Backup methods are snapshots and external (full database backup). You can enable point-in-time recovery. Depending on your business rules, you can set up automated backups and use a combination of backup methods to safeguard data.

You set up automated backups by attaching a database backup template to your database. Backup templates contain backup and recovery settings. You can select a database backup template during database creation or attach a template at a later time. You can also attach a different backup template at any time. If you have sufficient privileges, you can modify the template settings or create custom backup templates. The backup process picks up the latest settings the next time it runs. The modified settings do not affect backups that are in progress.

Using database backup templates ensures that you can take consistent database backups, meet recovery goals, and enforce your business rules. Data Director provides preconfigured database backup templates that provide a range of backup and recovery settings. If you are not sure how much storage your backups will require, start with the most conservative settings. You cannot decrease the backup storage allocation, but you can increase it. Monitor the database activity and the backup size until you have a good idea of the workload and backup space needed, and then adjust the storage amount.