SQL Server Articles, Tips, FAQs, Reviews, Whitepaper, News etc - MyTechMantra.com

PARTIAL Backup in SQL Server Step by Step Tutorial with Examples

Previous Page.. Begin Tutorial.. Next Page..

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).

This is Part 15 of 16 Part SQL Server Database Backup Tutorial. Click here to read it from the beginning….

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

BACKUP DATABASE [MyTechMantra] READ_WRITE_FILEGROUPS
TO DISK = 'C:\DBBackups\MyTechMantra_Partial.BAK'
WITH NOFORMAT, NOINIT, COMPRESSION, STATS = 25
GO

Create a DIFFERENTIAL PARTIAL backup Using TSQL command

BACKUP DATABASE [MyTechMantra] READ_WRITE_FILEGROUPS
TO DISK = 'C:\DBBackups\MyTechMantra_Partial.DIF'
WITH DIFFERENTIAL, COMPRESSION, STATS = 25
GO

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

Previous Page.. Begin Tutorial.. Next Page..

Related Articles

Chetna Bhalla

Chetna Bhalla

LESS ME MORE WE

Chetna Bhalla, the founder of MyTechMantra.com, believes that by sharing knowledge and building communities, we can make this world a better place to live in. Chetna is a Graduate in Social Sciences and a Masters in Human Resources and International Business. She is an alumnus of Vignana Jyothi Institute of Management, Hyderabad, India. After graduation, Chetna founded this website, which has since then become quite a favorite in the tech world. Her vision is to make this website the favorite place for seeking information on Databases and other Information Technology areas. She believes that companies which can organize and deploy their data to frame strategies are going to have a competitive edge over others. Her interest areas include Microsoft SQL Server and overall Database Management. Apart from her work, Chetna enjoys spending time with her friends, painting, gardening, playing the violin, and spending time with her son.

Newsletter Signup! Join 15,000+ Professionals




Be Social! Like & Follow Us...

Follow us

Don't be shy, get in touch. We love meeting interesting people and making new friends.

Recent SQL Server Tips