DIFFERENT TYPES BACKUP'S IN MSSql SERVER

There are different types of backup's are present, they are
1. Full backup:it is backup's total data base

Ex: BACKUP DATABASE test TO DISK='C:\Clr\test_full.bak';

2. Differential backup:
It is backup's recent transactions Or data in the database  from latest full backup on-words.

Ex: BACKUP DATABASE test TO DISK='C:\Clr\test_diff.bak' WITH DIFFERENTIAL

3. Transaction Log backup:
it is used for backup's the log file in the database


Ex: BACKUP LOG test TO DISK='C:\Clr\test_Log.bak'

4. Tail log backup: It is backup's the total transaction of the log file if the data base is corrupted.


Ex: BACKUP LOG test TO DISK='C:\Clr\test_tail_log.bak';

5. Striped backup:
it is internally shares the data to multiple files or multiple locations

Ex: BACKUP DATABASE test TO DISK='C:\Clr\test_part1.bak',DISK ='C:\Clr\test_part2.bak'
 /*(.....)*/
WITH FORMAT


6. Mirror backup : It will provides a Copy of same backup in another location

Ex: BACKUP DATABASE test TO DISK='C:\Clr\test_part1.bak'  MIRROR TO DISK ='C:\Clr\test_part2.bak'







http://mssqldevelopersaran.blogspot.com