Skip to main content
commvault.com commvault.com
Solved

mssql differential backup | Failed to get the last VSS full backup time string

D
Byte
Forum|alt.badge.img+13

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 database[XXXXX] and instance[XXXXX] ”

  • 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

 

Best answer by DanC

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

 

 

View original
    Did this answer your question?

    3 replies

    D
    Byte
    Forum|alt.badge.img+13
    • DanC
    • Author
    • Byte
    • 104 replies
    • August 23, 2022

    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

    D
    Byte
    Forum|alt.badge.img+13
    • DanC
    • Author
    • Byte
    • 104 replies
    • Answer
    • August 23, 2022

    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

     

     

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

    Well done!

    https://www.linkedin.com/in/michael-struening

    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