Sql Server Database Backup types :

Sql Server Database Backup types :

Sql Server Has mainly Four Types Of Data Backups :

(1). Full Backup.

(2).Differential Backup.

(3). File and File group Backup.

(4).Log File Backup.

(1)     Full Backup:- includes the all Data files and log files in a database. it is a complete set of data need to restore and recover the database in consist stat .

                       Or

 you can say that full backup is a complete set of file and files groups is equal to that full backup.

     

 

       (2). Differential Backup :- includes all the changes made since last full backup .differential backup in not a stand alone backup. when ever you required to restore or recover that data from differential backup then first you need to restore the full backup .if you have been taken multiple differential backups then you need to restore only latest one backup except that all backup.

(3)File or File groups backup :- Includes the backup of particular file and file groups that specified. Most of time you take currently used file and file groups backup that as  default file groups with a particular database .this type of backup you take only when database size in tera bytes

         (4)Log File Backup:-includes all the data recorded  in log file after taken the full backup or last log backup.

When you take log backup first time then it take backup of all log records that changed after that full backup.

If you take backup second or third time and so on then it start always last log backup.