|
Database backup methods. SQL Server offers many options for creating backups:
Full backups
A full database backup backs up the whole database. This includes part of the transaction log so that the full database can be recovered after a full database backup is restored.
Differential backups
A differential backup captures only the data that has changed since that full backup.
File and Filegroup backups
This allows you to backup each file independently instead of having backup the entire database. This is only relevant when you have created multiple data files for your database. One reason for this type of backup is if you have very large files and need to back them up individually.
Partial backups
A partial backup resembles a full database backup, but a partial backup does not contain all the filegroups.
Copy-Only backups
It does not disturb the original backup workflow, but just create a copy of the original database independently
|
