Update

======

We think we may have found the cause - this sytem was originally created on SQL 2008 R2 and later upgraded to SQL2014.

SQL 2008 R2 system databases apparently were set...

Hi

It seems to occur in the last part of the restore as the last part of the log is being laid out on disk. The database appears to work OK....

• This reply was modified 4 years, 5 months ago by  sqlguy7777.

Our experience with avamar us it's complete rubbish at doing backups and restores direct to database.

I'd do native SQL backups and use avamar to backup the SQL backup files.

Hi Jeff,

Thanks for your thoughts. Yep its been fun watching the Execs going off like a frog in a sock once they realized they had a dog on...

Hi

I agree with you completely, but we’re kind of stuck with it. The top brass have pumped big money into this thing and so won’t trash it, despite us asking...

Hey thanks everyone for your great responses so far.....

"What problems are you trying to solve?"

In a nutshell, we were having a debate in the office as...

Hi, thanks everyone for your replies.

Ok, so if my understanding correct then, all required database objects are loaded into RAM when RAM permits, including tempdb, but if there...

Hi Jeff,

I am not 100% sure, as an operator restarted SQL to clear tempdb. 

I guess what I'm trying to work out is whether one file hitting...

Sounds like the web server still has only the IP for the SQL Server it can currently see, either that or your DNS is faulty.
If the web server...

Agreed.

We normally reserve 15% of physical for the OS,

But be aware if you run any backup agents ( like Avamar or similar ),these can...

The fact its set in recovery mode sounds like a comms issue - the two servers I think cant see each other properly. AGs will do the same thing when...

SQL 2016 SP2 is a dog.

I'm, advising people to avoid it.

Its killed a few SQL servers.

It throws errors about Master database...

Hi

I had same issue - tried the package delay_whatsit setting , no good.

Tried the addition to the hosts file - no good.

Went back and changed settings back to original &...