Different types of BACKUPs avaialabe in SQL Server

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.
What is database replicaion?
The process of copying/moving data between databases on the same or different servers......
What are cursors in SQL Server?
Cursors allow row-by-row prcessing of the resultsets. Types of cursors: Static, Dynamic, Forward-only, Keyset-driven.......
What is a join and explain types of joins
Joins are used in queries to explain how different tables are related.......
Post your comment