April 17, 2020 at 4:12 pm
Just to make it very clear we are using AZURE VM just as if we were using any cloud provider. We are not using SQL AZURE. My SQL Server Agent Differentials are failing all of a sudden and I verified that it's a snapshot that is causing this. What has changed is the AZURE VM was recently rebooted(and had not been rebooted since myself or the System Administrator has worked here). I'm thinking that possibly the AZURE Backup VM must have somehow turned on since the reboot. All of my sql server agent backups(full diff, log) have been working just fine until this reboot.
Can someone give me an idea as to what I might need to turn off in order for my sql server agent diffs don't become invalidated. I guess the biggest question is, is it a choice that I either run Azure VM Backups or I have to turn it totally off for my diffs not to fail. If that's the case then, I'm possibly foresaking the entire VM which would have to be rebuilt from scratch if we don't leave it on.
April 17, 2020 at 5:04 pm
What error are you getting in your backups? That error message will be the best way to tell what is wrong...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply