Skip to main content
commvault.com commvault.com
Solved

Scheduling incremental Appaware backups for SQL Server

  • January 27, 2023
  • 3 replies
  • 202 views
Gaetano
Byte
Forum|alt.badge.img+8

Dear all,

We perform the backup of all our MSSQL VMs by aggregating them in one sublient, scheduled by an ad-hoc policy. The daily incrementals are scheduled at 7pm with the following options

  1. Notwithstanding the attached configuration, the SQL Server Appaware daily backups are always full. I remember I read somewhere that this is expected, is this correct?
  2. The Data checkbox is unchecked and this somewhat surprising for me. Shouldn’t it be selected for the job to backup SQL data?

Sorry if these questions sound a bit dummy but I inherited the management of the Commvault platform from a colleague and some choices from the past are still a bit unclear.

 

Thank you in advance

Gaetano

Best answer by Orazan

Good morning.  Yes App Aware backups of SQL are Full backups only.  The reason only transaction logs are checked is because transaction log jobs are actually run from the SQL client.  The database backup is backed up by the VSA agent.  If a restore is needed, that data is mined from a Virtual Server backup, not a SQL backup.  

View original
Did this answer your question?

3 replies

O
Vaulter
Forum|alt.badge.img+15
  • OrazanVaulter
  • Vaulter
  • 630 replies
  • Answer
  • January 27, 2023

Good morning.  Yes App Aware backups of SQL are Full backups only.  The reason only transaction logs are checked is because transaction log jobs are actually run from the SQL client.  The database backup is backed up by the VSA agent.  If a restore is needed, that data is mined from a Virtual Server backup, not a SQL backup.  

Gaetano
Byte
Forum|alt.badge.img+8
  • Gaetano
  • Author
  • Byte
  • 61 replies
  • January 27, 2023
Orazan wrote:

Good morning.  Yes App Aware backups of SQL are Full backups only.  The reason only transaction logs are checked is because transaction log jobs are actually run from the SQL client.  The database backup is backed up by the VSA agent.  If a restore is needed, that data is mined from a Virtual Server backup, not a SQL backup.  

Hi @Orazan , thank you for this much welcome clarification, this helps a lot.

O
1 person likes this
  • O
    Orazan
O
Vaulter
Forum|alt.badge.img+15
  • OrazanVaulter
  • Vaulter
  • 630 replies
  • January 27, 2023

Glad I could be of assistance.  Have a great weekend! đŸ˜€

Gaetano
1 person likes this
  • Gaetano
    Gaetano

Reply


Most helpful members this week

Terms & ConditionsCookie settings

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