Skip to main content

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

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

 


Many thanks @Jos Meijer !


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

Rgds,

Kamil


Your welcome :)

Nope, unfortunately I have never tried this option.


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


Sure @Mike Struening . I will.

 

Rgds,

Kamil


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


@Scott Reynolds Brilliant! 🙂 Many thanks!

 

Rgds,

Kamil


Hi guys,

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

Rgds,

Kamil


Reply