Skip to main content
Solved

Partial Backup od SQL Server


Kamil W
Commvault Certified Expert
Forum|alt.badge.img+11
  • Commvault Certified Expert
  • 83 replies

Hi guys,

Is Partial Backups (SQL Server) supported by Commvault?

 

https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/partial-backups-sql-server?view=sql-server-ver16

 

I searched documentation but I didn’t find any info about this?

 

Rgds,

Kamil

Best answer by Scott Reynolds

@Kamil W A partial backup restore should behave like a differential backup. Restoring the database would restore the full first then apply this partial backup. The only benefit of performing this type of backup is if the DB has a very large read-only file group so that it can be skipped during this partial backup since that file group will never change. If that is not the case there is no benefit. Note if leveraging this option on a full backup as well you are not protecting that read only file group.

It can however allow for more infrequent full backups saving time. Space generally should not be an issue if you are leveraging CV dedupe.

View original

9 replies

Jos Meijer
Commvault Certified Expert
Forum|alt.badge.img+17
  • Commvault Certified Expert
  • 638 replies
  • August 17, 2022

Located in the advanced schedule settings:

 

 

Quote documentation:

”Partial (Excludes read-only Filegroups)

If you want to exclude read-only filegroups from the backed up data, run a partial backup job.

A partial backup contains data in the primary filegroup, read-and-write filegroup and any optionally-specified read-only files. Partial backup of a read-only database contains only the primary filegroup.”

Source: https://documentation.commvault.com/2022e/expert/61510_advanced_backup_options_data.html

Procedure info: https://documentation.commvault.com/2022e/expert/18212_backing_up_sql_databases.html

 


Kamil W
Commvault Certified Expert
Forum|alt.badge.img+11
  • Author
  • Commvault Certified Expert
  • 83 replies
  • August 17, 2022

Many thanks @Jos Meijer !


Kamil W
Commvault Certified Expert
Forum|alt.badge.img+11
  • Author
  • Commvault Certified Expert
  • 83 replies
  • August 17, 2022

@Jos Meijer Have ever tried this? if so, did you have any restore problems?

Rgds,

Kamil


Jos Meijer
Commvault Certified Expert
Forum|alt.badge.img+17
  • Commvault Certified Expert
  • 638 replies
  • August 17, 2022

Your welcome :)

Nope, unfortunately I have never tried this option.


Mike Struening
Vaulter
Forum|alt.badge.img+23

@Kamil W , let us know your experience.  I’ll hold off on marking this as solved until you do.


Kamil W
Commvault Certified Expert
Forum|alt.badge.img+11
  • Author
  • Commvault Certified Expert
  • 83 replies
  • August 18, 2022

Sure @Mike Struening . I will.

 

Rgds,

Kamil


Forum|alt.badge.img+14

@Kamil W A partial backup restore should behave like a differential backup. Restoring the database would restore the full first then apply this partial backup. The only benefit of performing this type of backup is if the DB has a very large read-only file group so that it can be skipped during this partial backup since that file group will never change. If that is not the case there is no benefit. Note if leveraging this option on a full backup as well you are not protecting that read only file group.

It can however allow for more infrequent full backups saving time. Space generally should not be an issue if you are leveraging CV dedupe.


Kamil W
Commvault Certified Expert
Forum|alt.badge.img+11
  • Author
  • Commvault Certified Expert
  • 83 replies
  • August 18, 2022

@Scott Reynolds Brilliant! :) Many thanks!

 

Rgds,

Kamil


Kamil W
Commvault Certified Expert
Forum|alt.badge.img+11
  • Author
  • Commvault Certified Expert
  • 83 replies
  • August 19, 2022

Hi guys,

The information you provided is enough for me. Let’s close this post out.

Rgds,

Kamil


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings