Viewing 13 posts - 1 through 13 (of 13 total)
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...
June 4, 2020 at 7:00 am
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....
June 4, 2020 at 12:03 am
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.
June 2, 2020 at 9:57 am
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...
January 6, 2019 at 12:22 am
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...
January 5, 2019 at 2:36 am
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...
January 4, 2019 at 10:57 pm
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...
January 3, 2019 at 11:59 pm
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...
November 22, 2018 at 9:29 pm
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...
October 11, 2018 at 11:36 pm
We normally reserve 15% of physical for the OS,
But be aware if you run any backup agents ( like Avamar or similar ),these can...
October 11, 2018 at 10:35 pm
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...
October 11, 2018 at 10:29 pm
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...
October 11, 2018 at 10:20 pm
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 &...
June 19, 2011 at 10:03 pm