How many types of SQL Server database backups and Recovery Models are

1.	How many types of SQL Server database backups and Recovery Models are there?
Answer» SQL Server supports the following types of database backups: Full Backup – It contains a COMPLETE backup of the database. Differential backup – Differential backup is also known as incremental backup. It contains changes happen after the last full backup. Log Backup – Log backup contains a backup of the transactional log after last log backup. It contains both committed &AMP; uncommitted transactions. Copy-Only Backup – SPECIAL backup type that does not IMPACT the sequence of regular backups and gives you a copy of the complete database. FILEGROUP Backup – SQL gives you the capability of one or more filegroup backup in place of complete database backup. Partial Backup – Partial backup helps you to take a backup of specific data from different files or filegroups. SQL Server database backups are supported by all 3 recovery models: Simple Full Bulk-logged

How many types of SQL Server database backups and Recovery Models are there?

Answer»

SQL Server supports the following types of database backups:

Full Backup – It contains a COMPLETE backup of the database.
Differential backup – Differential backup is also known as incremental backup. It contains changes happen after the last full backup.
Log Backup – Log backup contains a backup of the transactional log after last log backup. It contains both committed &AMP; uncommitted transactions.
Copy-Only Backup – SPECIAL backup type that does not IMPACT the sequence of regular backups and gives you a copy of the complete database.
FILEGROUP Backup – SQL gives you the capability of one or more filegroup backup in place of complete database backup.
Partial Backup – Partial backup helps you to take a backup of specific data from different files or filegroups.