SQL Server backups
Backup's
===========
full::
backup database dbname to disk='path'
Differential::
backup database dbname to disk='path'with differential
log::
backup log dbname to disk='path'
mirror::
backup database dbname to disk='path'
mirror
backup database dbname to disk='path' with format
copy_only::
backup database dbname to disk='path'with copy_only
Split backup::
backup database dbname to disk='path',disk='path'
Tail log backup::
backup log dbname to disk='path' with no_truncate
Partial backup::
backup database dbname read_write_filegroup to disk='path'
partial differential backup::
backup database dbname read_write_filegroup to disk='path'with differential
File&File Group Back up::
backup database
Advertising