Viewing 15 posts - 3,241 through 3,255 (of 9,253 total)
Shawn Melton (6/12/2014)
If the quorum drives show offline on server1, then this is no longer the active node, it is server2.
It doesnt matter where the quorum drive is online,...
June 13, 2014 at 5:29 am
It will take as long as it needs, have you thought of performing this first in a test\QA env to see what the results are?
June 13, 2014 at 5:25 am
post screenshot of the following registry location
HKEY_LOCAL_MACHINE\SOFWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.R8\MSSQLServer\Parameters
June 6, 2014 at 5:02 am
Ratheesh.K.Nair (5/30/2014)
Perry Whittle (5/30/2014)
Ratheesh.K.Nair (5/30/2014)
I have given everyone full access to the location but still gets the same error.
If inheritance is turned off you could see this issue. Open...
May 30, 2014 at 10:39 pm
Ratheesh.K.Nair (5/30/2014)
I have given everyone full access to the location but still gets the same error.
If inheritance is turned off you could see this issue. Open the security properties...
May 30, 2014 at 12:53 pm
if you're prepared to flatten and re provision the server it doesnt matter where you install it, physical or virtual!
May 30, 2014 at 3:05 am
DBA From The Cold (5/29/2014)
May 29, 2014 at 10:57 am
It's dependant upon the machines requirements. For example if you have a host server with 64GB RAM and 16 CPUs and you require the VM to have 32GB RAM and...
May 29, 2014 at 7:41 am
Ratheesh.K.Nair (5/26/2014)
I got the below messages.
C:\Program Files\Microsoft SQL Server\MSSQL10_50.R8\MSSQL\Binn>sqlservr.exe -m -
sR8
2014-05-26 16:14:33.41 Server Error: 17058, Severity: 16, State: 1.
2014-05-26 16:14:33.41 Server ...
May 26, 2014 at 8:25 am
Minto Minto(quendans) (5/26/2014)
recently we configured sql 2012 cluster. After installing ,i tried to check the failover from node to node.Form active node i stopped services but it is not getting...
May 26, 2014 at 7:25 am
Carlton Leach (5/21/2014)
does it allow you to:- create a 2 node cluster, 2 Standalone instance, with no shared disk?
Yes that's pretty much a basic configuration with an AlwaysOn...
May 23, 2014 at 11:00 am
curious_sqldba (5/20/2014)
thank you for the wonderful post.
You're welcome.
curious_sqldba (5/20/2014)
May 20, 2014 at 3:46 pm
Granting SQLAgentReaderRole will automatically grant the base SQLAgentUserRole too.
A user who has the base User role can only see jobs that they actually own, they'll see nothing else.
A user who...
May 20, 2014 at 9:05 am
So, you have a new server for your planned cluster to add to the current machine with the stand alone instance.
Do you have a maintenance window or agreed downtime period...
May 20, 2014 at 7:56 am
TheSQLGuru (5/20/2014)
Perry Whittle (5/20/2014)
There'll be some history somewhere. Have you thought of logging the job step output to a text file?
Taking another opportunity to steer the user (and every SQL...
May 20, 2014 at 7:46 am
Viewing 15 posts - 3,241 through 3,255 (of 9,253 total)