Types of Backup in SQL Server

[Jagdish Gada]

Hello, I want the details about the Database backup facility in the SQL server 2000. I wanted to know the types of backup available in SQL Server. If anyone knows the types of backup with their details then give me reply regarding that. I am beginner in the SQL database language.

[Praetor]

There are basically three types of backups mostly used in the SQL server. They are as follows:

• Full Backup
• Differential Backup
• Transcational Log Backup

If you want the detail information about this then you can make use of the book such as Backup and Recovery Best Practices for Microsoft SQL Server 2005 which will give you deep understanding about it.

[Katty]

I am also beginner in SQL server. I have a book named "SQL Server Complete Reference". From that I come to know that there are following types of backup available in SQL server:

1. Full Backup
2. Differential Backup
3. Transaction Backup
4. Taillog Backup
5. Copy_only Backup
6. Mirror Backup
7. Files and File group Backup
8. Partial Backup

From all of this, first two are basic.

[kelfro]

SQL server 2000 has following three basic backup types:

1. Database (or Full) : This backup is default for SQL server 2000 and this is the starting point whether you use other backup type or this. It includes all database entries.
   
2. Differential : This is second type of backup structure. It will take backup of all the data from the date where you have taken Full backup. This is faster while taking backup and also for restoring it. It considers only for the changed database values or new added values.
   
3. Transaction log : This type of backup will find out updations to your database one by one. So it can provide you history of all the transactions.

[Zecho]

Hello, I am also new in SQL Server database language. And I have a list of books which can be useful to you while finding all these details. I am giving you that list, you can select best one for your requirement.
Books for Reference:

1. SQL and Relational Theory: How to Write Accurate SQL Code
2. Data Quality Assessment
3. Data Modeling Theory and Practice
4. Physical Database Design
5. Data Modeling Made Simple

[Reegan]

There are of five types of Backup available in SQL server:

1. Database
2. Transaction
3. Differential
4. File or Filegroup
5. Snapshot Backups