My first step when debugging things like that is to look at the data insert steps (anything that has an "INSERT" statement) and run the code below the that to...

Quick check with google, SSRS supports managed service accounts:

https://dba.stackexchange.com/questions/173792/ssrs-and-managed-service-account-impossible-to-configure#:~:text=Yes%20you%20can%20run%20SSRS%20with%20a%20Managed,need%20to%20install%20the%20MSA%20on%20the%20server.

I personally have not set that up and used it with a .NET app nor with SSRS, but it appears that what...

My approach would be if you ABSOLUTELY need to use your .NET app for this would be to encrypt the password using some certificate that is on the server running...

Data corruption is a tricky thing to correct and can result in larger problems down the road.

I'd either hire a DBA consultant who specializes in data recovery to resolve the...

I should say one thing - before changing compat levels, I would test things out on a sandbox. There ARE valid use cases for using the old CE or older...

I agree that re-doing the backup strategy seems like overkill, especially when it is working. Mind you, as a long term solution and for future supportability, I would be moving...

• This reply was modified 2 years ago by Mr. Brian Gale.

That sounds like it may be a bug in SSMS then... but oof... using the edit GUI in SSMS? I find that to be clunky and painful to work with....

• This reply was modified 2 years ago by Mr. Brian Gale.

Pretty sure that it is saying that you are  using an old CE because you are running SQL Server 140 but have database compatibility in 120. So the CE is...

As another random thought - Are you seeing any pattern to when it blanks out? Like is it good at 8:02 but by 8:15 it is blank? If so, I...

Just thought of a small scenario that MAY not impact you, but thought I'd toss this in here too - do you have any heaps? The reason I ask is,...

Makes more sense to me now, but I know I still prefer having a bunch of "useless" backups rather than an inconsistent backup strategy. But that's just my opinion. Doesn't...

I could be mistaken, but what you set up is an isolated network so SQL can talk to AWS for authentication using AD authentication BUT you have no computers joined...

As a guess (no access to or history of your system) - I would say that in some old old version of SQL Server, single user mode on system databases...

Possibly a silly question, but is there a reason for this obscure backup strategy? I am just trying to figure out why you would want to have backups taken sporadically...

One thing I would be careful of is that using AKV means your SQL instance relies on a cloud service to decrypt its data. This is important for 2 big...