Simple relationship between the SQL Server recovery model, Backup mode, and restore Mode

	Recovery mode	Backup method	Restore Mode
Recovery mode	Simple mode	Full backup, differential backup	Full restore, differential restore
Recovery mode	Full mode	Full backup, differential backup, transaction log backup	Full restore, differential restore, transaction log restore (can be restored to any point in time of backup)
Recovery mode	Large-capacity logs	Full backup, differential backup, transaction log backup	Full restore, differential restore, transaction log restore (non-restorable to any point in time of backup)

Note:

Recovery mode: Simple mode marks the log as "reusable" in the process of full and differential backup, that is, the log is truncated;

Recovery mode: Full mode in full and differential backups do not mark the log, only transaction log backups flag the log;

Recovery mode: The bulk log records only the results for large batches of operations (such as creating indexes) when logging the transaction log, and does not log the complete process, as well as full and differential backups that do not flag logs, only transaction log backups that flag the logs;

This article is from the "Step by Step" blog, so be sure to keep this source http://281816327.blog.51cto.com/907015/1423982