Viewing 15 posts - 1 through 15 (of 26 total)
Thank you Steve.
I did not know that Ola's site has solution for HAG scenario too.
I will give it a shot.
October 9, 2019 at 5:32 pm
Well , after I failed over the primary to the second node , I tried to execute the sql agent job manually on the second node.
It failed with an error saying that...
March 23, 2018 at 12:10 pm
Thanks for the tip.
I removed all GO lines in the script and for each batch I appended a semi-colon ; to the line.
It seems to have worked.
March 21, 2018 at 4:23 pm
Based on past experience with A SQL instance on a VM, I changed the Startup type to "Automatic delayed " from "Automatic" and rebooted the 2 nodes one by one.
That...
November 28, 2017 at 9:44 am
Based on what you mentioned , I rebooted one by one . Even then the issue persists.
The SQL instances are in stopped state.
I see in the logs...
November 22, 2017 at 11:31 am
I tried to run it one more time by excluding the large DB . Did not help.
Immediately the PLE tanks to ZERO.
I must be missing somethign here.
February 24, 2017 at 4:40 pm
Steve ,
Thanks for responding.
This is a VM . A very small server.
Hardly heavy use. I would say , 6 GB RAM
SQL Memory set at MAX 4...
February 24, 2017 at 4:24 pm
January 23, 2017 at 6:09 pm
January 12, 2017 at 2:09 pm
January 12, 2017 at 2:06 pm
Hi , IDERA offers powershell plus software as a free tool. They also provide several scripts that are developed and shared by people for public use. May be...
June 16, 2016 at 10:19 am
set this line as below :
SendEmailToUserAlias>False</SendEmailToUserAlias>
June 15, 2016 at 11:29 am
Hi All ,
Just wanted to update the issue with this resolution :
The settings were missing in the web.config in the ReportManager folder.
After we made the change and restarting the SSRS...
June 5, 2016 at 10:10 am
Thank you for the response.
There is something funky about this particular report. The report was auto upgraded when SQL 2005 was migrated to sql 2012 instance. It was never touched...
June 3, 2016 at 10:24 am
Hello :
I am having a same issue.
SSRS 2012 upgraded from SSRS 2005 few years ago.
<httpRuntime maxRequestLength="1048576" executiontimeout="10800" />
I checked the web.config file and it is set to 1048576. much beyond...
June 2, 2016 at 12:20 pm
Viewing 15 posts - 1 through 15 (of 26 total)