There are three types of backups that can be performed on a SQL Server: full, differential, and transaction log. The type of backup that is best for your situation depends on how often your data changes and how much data needs to be restored.
A full backup backs up all the data on the server. This is the most complete backup and can be used to restore the server to its current state. A full backup should be taken at …
