No worries, I knew it was a long shot to ask if you remember restarting a server 5 years ago ??

Thanks for the reply anyway.

H Dave-L

how did you get on when you restarted the service? I know this is an old thread but would be useful to know if it fixed the issue and...

Hi zlthomps

I know this is an old thread but I am interested to hear how you got on after enabling T1800 at startup?

Thanks

Angeline

Hi

I have experienced a similar issue. Production Availability Group is on a SAN with 512 bytes per physical sector.  We have no issue in the AG but when we restore...

Lynn, I would have said the same however I am the only user accessing this server.
Johan, Quite possible I guess. I've installed multiple of instances in same set up...

For the benefit of anyone that comes across this thread and is experiencing the same issues...

For some, yet unknown, reason the SQL virtual service account NT SERVICE\MSSQL$MSSQLSERVER2016 lost permissions...

Hi Johan

Why is what I am trying to figure out. I don't know why they are stuck at recovery pending.
Yes correct it does appear that the service account no longer...

Got it sorted - lack of knowledge when reading the c# code where it specified the database ..... I was looking at the wrong one!!!