SQL Server 2017 Backup -1


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.

  1. Media Failure
  2. User-Based Errors like drop table
  3. Disk Errors or corruption
  4. 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.

  • Full
  • Differential
  • Transaction Log


I will explain these types of Database backups in the next post.



Do you want to learn Microsoft SQL Server DBA Tutorials for Beginners, then read the following articles.


 2,274 views last month,  2 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply

Your email address will not be published. Required fields are marked *