The backup strategy consists of defining what data will be copied, where it will be stored, what type of backup and when the process will be performed. You need to find a balance between the amount of resources you have available and the amount of data you need to have available.
After all, the performance of incremental backups during the day cannot coincide with peak moments of access to the system, otherwise the performance of the database is drastically reduced.
To determine the ideal backup strategy, we also need to address the concept of the Business Continuity Plan, which consists of a set of preventive strategies and actions that aim to ensure the maintenance of essential company services after a crisis.
He must be an ally of the backup strategy. So you need to have a plan that predicts how much your business will accept to lose data and how long it can stand still.
The Business Continuity Plan is determined using the RPO and RTO metrics, which mean:
RPO: Recovery Point Objective is the metric that analyzes a company's data loss tolerance. She answers the question, "How much can you lose?" Through it it is possible to determine the time between backups and the amount of data that can be lost between them.
RTO: Recovery Time Objective is the metric that determines the maximum time that a company can have its system unavailable after a disaster. She answers the question, "How long can you stand still?" With it, you can measure the time that your company can afford to survive after a failure until its operations are restored.
“These two metrics are essential for a company to develop a backup strategy that is appropriate for the reality of its business, Mauro”
The Microsoft Office Specialist is considered an integral part of many businesses as they skillfully use an office suite to perform essential daily duties like written correspondence through MS-word, email programs, analyzing data sets.