SQL Server offers a wide range of options to back up databases. These include the following:
• Full— Complete database backup that includes transaction logs.
• Differential— All data changes since the last full backup is backed up.
• Transaction log backup— All transactions performed against the database since the last full backup or transaction log back up is backed up.
• File and file group backup— A portion of the database is backed up.
• Partial backup— All data in the primary group, every read-write file group, and any specified files are backed up. File groups marked read-only are skipped.
• Differential partial backup— Although similar to partial backup, this backup records only changes to the data in the file ...