AnsweredAssumed Answered

Nimble VSS snapshots affecting RedGate SQL backups

Question asked by Jose C on May 20, 2016
Latest reply on Jul 25, 2016 by Chris Aylott

VSS backups were enabled on all our MSSQL servers few weeks ago. They are running every hour. And since enabled, my regular SQL backups are failing. This does not happen on a specific database but randomly and when it does, RedGate just retries the backup. But this is causing some delays and the logic is skipping a purging step, at the end of the day, I have extra backups that were not deleted because of this.

 

msdb states that the snapshot backup takes around 30 seconds per database. IT states that Nimble's dashboard or logs says it only takes one second. I do believe it takes longer than that and it is affecting the storage and temporary blocking or disconnecting MSSQL affecting backups while it lasts.

 

Have someone seen this before? I want these two to coexists, but the errors and problems are happening every day.

Outcomes