Whether caused by hardware failure, software errors or malicious actions, there is always a possibility of data loss. You should be prepared to deal with the loss of data and where possible recover your data. How well you plan for the possibility of failure, design of data protection strategy and the implementation of those plans can make the difference between a disaster and an inconvenience. Perhaps the most important tool for ensuring data recovery is a reliable backup of your database.

Checkout the part-1 of my three part article series on SQL SQL Server Database Backups and Recovery Models here, in which you will learn about basics of SQL Server backup process and database recovery models.

This article is published on SSWUG.org.