Skip to main content
commvault.com commvault.com
Answer

Partial Backup od SQL Server

  • August 17, 2022
  • 9 replies
  • 245 views
Kamil W
Certified Expert
Forum|alt.badge.img+10

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.

9 replies

Jos Meijer
Community All Star
Forum|alt.badge.img+16
  • Jos MeijerCommunity All Star
  • Community All Star
  • 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
Certified Expert
Forum|alt.badge.img+10
  • Kamil WCertified Expert
  • Author
  • Certified Expert
  • August 17, 2022

Many thanks @Jos Meijer !

Kamil W
Certified Expert
Forum|alt.badge.img+10
  • Kamil WCertified Expert
  • Author
  • Certified Expert
  • August 17, 2022

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

Rgds,

Kamil

Jos Meijer
Community All Star
Forum|alt.badge.img+16
  • Jos MeijerCommunity All Star
  • Community All Star
  • August 17, 2022

Your welcome :)

Nope, unfortunately I have never tried this option.

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

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

https://www.linkedin.com/in/michael-struening
Kamil W
Certified Expert
Forum|alt.badge.img+10
  • Kamil WCertified Expert
  • Author
  • Certified Expert
  • August 18, 2022

Sure @Mike Struening . I will.

 

Rgds,

Kamil

S
Vaulter
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
Certified Expert
Forum|alt.badge.img+10
  • Kamil WCertified Expert
  • Author
  • Certified Expert
  • August 18, 2022

@Scott Reynolds Brilliant! :) Many thanks!

 

Rgds,

Kamil

Kamil W
Certified Expert
Forum|alt.badge.img+10
  • Kamil WCertified Expert
  • Author
  • Certified Expert
  • August 19, 2022

Hi guys,

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

Rgds,

Kamil

Terms & ConditionsCookie settingsAccessibility statement