|
Explain different types of Backups available in SQL Server?- SQL server provides different types of backups which is used to restore a database to a former state.
- These backups use a file or set of files to capture the database state.
Following are the types of Backups available in SQL Server:
1. Full database backup.
2. Differential database backup.
3. Transaction log backup.
4. File group backup.
1. Full database backup:
- In this, it will backup all the information in the database.
- It is mostly used for disaster recovery and takes the longest time to backup.
2. Differential database backup:
- In this, the database is divided into partitions that have been modified.
- It is most suitable for large databases.
- It contains the changes from previous backups.
3. Transaction log backup:
- The changes are only logged in the transaction log.
- It has all the changes that logged about a database.
4. File group backup:
- It is used to recover individual files or file groups.
- It helps in recovery only the required file or file group for disaster recovery.
|
