Skip to main content

Hello team,

 

Just wondering if OS security patching & reboot will break last vss full backup time string or any other thing could potential cause this type of failure

 

***

mssql lives in Aazure and Last night differential backup were failing for all instances and gave a following error “Failed to get the last VSS/Snap full backup time string for databaseaXXXXX] and instancetXXXXX] ”

  • Backup history shows the previous diff backup completed successfully on 21/Aug 10:30PM
  • Observed the previous full backup completed successfully for both instances and instances have configured to use with VSS 
  • server last reboot was on 20/Aug after OS security patching
  • sqlida.log only shows error “Failed to get the last VSS full backup time string”
  • no error in wins app/system event during the backup

 

I will ask our DBA to run a query of the instances in question on sql management studio to see if the timeStamp for the last full backup is indeed present and report back

looks like chain get corrupted as theLastFullBackupTimStamp show difference between job history and sql query or could be the last sql full backup ran outside of Commvault that break LSN while backup was done using VSS.

I will run a new full and that should be resolved the issue

 

 

Well done!

Reply


Terms & ConditionsCookie settings