You work for a local state government agency A recent audit

You work for a local state government agency. A recent audit has revealed your agency does not have an adequate backup plan. Before any disaster recovery plan can be crafted, you have been tasked to provide the following information:

Explain the objectives of a backup and recovery strategy for databases.
Explain the types of backup plans and how they can be used to meet different recovery objectives.

Solution

Objectives of BackUp Plan and Recovery Stragtegy for Databases would be to maximize data availability and minimise data loss.And in real world things are meant to break so is database and for any application for business to run we need stored data all the time and we cannot rely only on just one originla copy of it hence we need to have backup of it and whenever database goes down a recovery strategy helps to recover data using backup. Therefore a backup plan and recovery strategy are design with timed jobs.

Types of BackUp plans:

Incremental Backups :As the name suggest it only stores the changes from the previous backups,hence gives a faster recovery and a better performance.

Binary Compression : It reduces the size of backup , hence give more storage area for backups.

Encrypted Backups : in this backups are encrypted and gives more security.