---
title: "How many types of database backup ?"  
description: "How many types of database backup ?"  
author: "Anonymous User"  
published: 2019-06-14  
updated: 2020-09-21  
canonical: https://www.mindstick.com/interview/23526/how-many-types-of-database-backup  
category: "mssql server"  
tags: ["sql server", "sql", "sql server 2008", "sql server 2012"]  
reading_time: 1 minute  

---

# How many types of database backup ?

These are some different types of SQL Server database backups.

Following below :

- Full
- Differential
- Transactional Log(T-Log)
- Copy-Only
- File
- FileGroup
- Partial
- Mirror

The type of database backup depends on the database recovery model of the database.

## Answers

### Answer by Anonymous User

These are some different types of SQL Server database backups.

Following below :

- Full
- Differential
- Transactional Log(T-Log)
- Copy-Only
- File
- FileGroup
- Partial
- Mirror

The type of database backup depends on the database recovery model of the database.


---

Original Source: https://www.mindstick.com/interview/23526/how-many-types-of-database-backup

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.