In this article, I will explain you how the Backup is done in SQL Server 2017 and what kind of importance it is.
Database Backup is that One Copy of Stored Data to Disk or Tape In case of unexpected errors or disasters. This backup can be used for Restoring and preventing data loss. So Backup is one of the most critical issues in database administration especially for large-scale telecommunication companies, banks, government agencies and large holdings.
The loss of data causes material and reputation-causing events in the large-scale companies or in important projects, so companies must always keep more than one copy of the Databases or Files.
The causes of data loss that may occur in companies and systems are as follows.
- Media Failure
- User-Based Errors like drop table
- Disk Errors or corruption
- Natural disasters like Earthquake floods.
An example scenario: Now, almost no one does not keeps a large amount of money under the pillow in the house or in their pocket and keeps it in the bank. Assume that the account database that holds the Account transactions are corrupted. How can the bank recover this error ? Therefore, banks are required to take lots of backup according to their criticality for the protection of information systems.
There are three types of Database backups in the SQL Server. These are like following.
- Transaction Log
I will explain these types of Database backups in the next post.