Viewing 12 posts - 1 through 12 (of 12 total)
Could please provide more details for us?
What version of SQL Server are you running?
Is the underlying environment working fine?
Have you made a recent change such as applying...
March 24, 2013 at 5:50 am
Awesome!!!! I'm glad you got it up and running. Good point about bouncing SQL, LOL...
March 23, 2013 at 8:03 am
You are right, there is no need under Server 2008. I really thought you did but then confirmed it from multiple sources that you did not. My bad.
March 23, 2013 at 7:57 am
And Perry is correct, there is no need for the SQL Server resource to be restarted under 2008 R2 when adding a dependency. That was only necessary under Server 2003,...
March 23, 2013 at 7:55 am
LOL, Perry, please don't take it personally. You mentioned ALL shared disks and since quorum and DTC are shared disks hence my posts was valid regarding that even know they...
March 23, 2013 at 6:59 am
You can't use the gui configuration management tool since its a core install. Use powershell instead. Use the following example below that I found on mdsn's blog by Dan Benediktson....
March 22, 2013 at 10:08 pm
Actually from what I understand not all shared disks are dependencies for the SQL Server resource. The Quorum and DTC LUNS will not be able to be added as dependencies...
March 22, 2013 at 9:48 pm
Hmm, great point. I was not sure of the answer so I researched it a bit and it seems that no indexes of any type are allowed to be created...
March 22, 2013 at 9:34 pm
Hello,
Assuming that your disks are properly configured and successfully added to cluster manager (which they seem to be on paper), the final step you are missing is to add...
March 22, 2013 at 9:23 pm
You can also use SQL Server 2012 Always ON Availability Groups and using a secondary replica for reporting. This way you also accomplish redundancy and reporting at the same time....
March 15, 2013 at 9:41 am
I have found a direct correlation between my experience levels and the amount of anxiety I experience. As long as I feel good about my ability to recover, the anxiety...
March 7, 2013 at 10:22 am
Look at the SQL Server Logs from within SQl Server Agent's Error Logs. Also review the system and application logs within event viewer. Something is causing SQL Server to restart....
March 7, 2013 at 10:02 am
Viewing 12 posts - 1 through 12 (of 12 total)