Connect With

Like Us on Facebook    Follow Us on Twitter     Subscribe to our Feeds     Subscribe to NewsLetter

Different Types of SQL Server Backups

Read Comments   |   Related Tutorials: SQL Server Database Backup Options > Next Topic: Permissions Required for Backups

Page 6 / 16

Click here to read this tutorial from the beginning...


SQL Server supports different types of backups for databases. However, which type of a database backup can be performed totally depends upon the recovery model of the database one choose. If you are unclear of the advantages and disadvantages of each recovery model then we would recommend you to read about SIMPLE, FULL and BULK-LOGGED first. In this tutorial we will discuss in detail each of the available database backup options and how to perform backups using TSQL scripts and with SQL Server Management Studio (SSMS).

Different Types of SQL Server Backups which you can perform are:-

  • Full Backups
  • Differential Backups
  • Transactional Log Backups
  • Copy-Only Backups
  • File Backups
  • FileGroup Backups
  • Partial Backups
  • Mirror Backups

Clicking Next Page button to continue reading the topics and click on the Previous Page button to revisit the previous topic.

Previous Page.. Next Page..

Learn More...

Last Updated On: Feb 12, 2014

Share this Article

Receive Free SQL Server Tips and Keep Learning
Get Free SQL Server Tips

Please leave your Valuable Comment or Let us know how this article helped you: