Chetna Bhalla
|
 |
|
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 T-SQL Enhancement in SQL Server 2016
- Mastering FORMATMESSAGE in SQL Server 2016: Ad-Hoc String Formatting
- 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
- AUTOGROW_SINGLE_FILE in SQL Server 2016: Syntax & TF 1117 Comparison
- ALTER TABLE WITH (ONLINE=ON | OFF) T-SQL Enhancement in SQL Server 2016
- DROP IF EXISTS – Simplifying Database Cleanup Scripts in SQL Server 2016
- How to Truncate Specific Partitions in SQL Server (Fast & Efficiently)
- 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
Ashish Kumar Mehta