PARTIAL Backup in SQL Server Step by Step Tutorial with Examples
Related Tutorials: SQL Server Database Backup Options>
Next Topic: TAIL-LOG Backups in SQL Server
Page 15 / 16
As per MSDN "PARTIAL Backups are designed for use under SIMPLE recovery model; thereby to improve flexibility to backup very large database which contain one or more read-only Filegroups. They are useful whenever you want to exclude read-only Filegroups. A partial backup resembles a full database backup, but a PARTIAL backup does not contain all the Filegroups. Instead, for a read-write database, a partial backup contains the data in the primary FileGroup, every read-write FileGroup, and, optionally, one or more read-only files. A partial backup of a read-only database contains only the primary FileGroup." For more information, see Partial Backup (SQL Server).
In the previous example we created a database named MyTechMantra which had three data files and one transactional log file. Two of the data files are residing in PRIMARY FileGroup and one data file was residing in a READ-ONLY FileGroup. Now to create a FULL PARTIAL Backup use the below TSQL script.
Create a FULL PARTIAL backup Using TSQL command
TO DISK = 'C:\DBBackups\MyTechMantra_Partial.BAK'
WITH NOFORMAT, NOINIT, COMPRESSION, STATS = 25
Create a DIFFERENTIAL PARTIAL backup Using TSQL command
TO DISK = 'C:\DBBackups\MyTechMantra_Partial.DIF'
WITH DIFFERENTIAL, COMPRESSION, STATS = 25
Clicking Next Page button to continue reading the topics and click on the Previous Page button to revisit the previous topic.
- TAIL-LOG Backup in SQL Server Step by Step Tutorial with Examples
- Different SQL Server Recovery Models Step by Step Tutorial with Examples
- Permissions Required to Take Database Backup in SQL Server
- COPY_ONLY Backup in SQL Server Step by Step Tutorial with Examples
- Mirrored Backup in SQL Server Step by Step Tutorial with Examples
- How to Create Full Database Backups in SQL Server Using SQL Server Management Studio
Last Updated On: Feb 12, 2014
Please leave your Valuable Comment or Let us know how this article helped you: