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.
This is Part 6 of 16 Part SQL Server Database Backup Tutorial. Click here to read it from the beginning….
In this tutorial we will discuss in detail different types of SQL Server backups which are available and how to perform backups using TSQL scripts and by using SQL Server Management Studio (SSMS).
Different Types of SQL Server Backups you can create are:-
- Full Backup
- Differential Backup
- Transaction Log Backup
- File Backup
- FileGroup Backup
- Partial Backup
- Copy-Only Backup
- Mirror Backup
Clicking Next Page button to continue reading the topics and click on the Previous Page button to revisit the previous topic.
Related Articles
- SQL Server WHERE Clause T-SQL Tutorial with Examples
- SQL Server ORDER BY Clause T-SQL Tutorial with Examples
- SQL Server SELECT TOP Clause T-SQL Tutorial with Examples
- SQL SELECT | SQL QUERY | SQL SELECT Statement T-SQL Tutorial with Examples
- SERVERPROPERTY Function T-SQL Enhancement in SQL Server 2016
- FORMATMESSAGE Statement T-SQL Enhancement in SQL Server 2016
- STRING_SPLIT Function and STRING_ESCAPE Function in SQL Server 2016
- COMPRESS and DECOMPRESS T-SQL Enhancement in SQL Server 2016
- ALTER DATABASE SET AUTOGROW_ALL_FILES T-SQL Enhancement in SQL Server 2016
- ALTER DATABASE SET AUTOGROW_SINGLE_FILE T-SQL Enhancement in SQL Server 2016
- ALTER TABLE WITH (ONLINE=ON | OFF) T-SQL Enhancement in SQL Server 2016
- DROP IF EXISTS SQL Server T-SQL Enhancement in SQL Server 2016
- TRUNCATE TABLE WITH PARTITIONS T-SQL Enhancement in SQL Server 2016
- T-SQL Enhancements in SQL Server 2016 for Developers and DBAs
- TAIL-LOG Backup in SQL Server Step by Step Tutorial with Examples
- PARTIAL Backup in SQL Server Step by Step Tutorial with Examples