Viewing 15 posts - 1,936 through 1,950 (of 9,253 total)
swoozie (7/6/2015)
SQLsrvr.exe -m this did not work either -m unrecognizable
You have to run this from the folder where the exe lives, usually
C:\Program Files\Microsoft SQL Server\MSSQL11.INSTANCEID\MSSQL\Binn
As i said before...
July 6, 2015 at 1:48 pm
Arestas (7/6/2015)
I don't have any access to AD or DNS.
A windows server failover cluster requires an Active Directory domain and a valid DNS server. It is possible to implement clustering...
July 6, 2015 at 1:44 pm
can you tell us a bit more about your environment, is this a test system?
Who installed\controls the domain controller(s) and DNS server(s)?
July 6, 2015 at 12:25 pm
when running as a sql server account the job will impersonate the service account at the OS level. If the service account has permission to the folder then it will...
July 6, 2015 at 12:10 pm
that document doesn't do anymore than what you say you were doing except that your directly modifying the service startup.
Inconsistencies I can see are you start a default instance of...
July 6, 2015 at 10:22 am
feersum_endjinn (7/6/2015)
It was more of a drive-letter swap. The reason was that new, faster storage has been provisioned so data on the old drive was moved to the new....
July 6, 2015 at 10:17 am
yes, until the IP is bound to the adapter you cannot use it, but as I said you're still pushing all that traffic down the 1 NIC!
July 6, 2015 at 10:14 am
giri10488 (7/6/2015)
which things he has to monitor & how?
main role of dba if one node goes...
July 6, 2015 at 10:12 am
Arestas (7/6/2015)
Well, no.
To use the IP you wanted to use you would need to add this to your NIC IP address list
July 6, 2015 at 4:12 am
Arestas (7/6/2015)
Figured already that if i use the Ip of the networkcard (10.0.255.170) instead of a virtual ip (10.0.255.83) all work as a charm. Problem here is that...
July 6, 2015 at 4:11 am
Mike Good (7/1/2015)
Interesting and well written, but I disagree with your slant.
Thanks for the feedback
Mike Good (7/1/2015)
July 6, 2015 at 4:09 am
the server you're putting sql server onto, is it a domain controller
July 6, 2015 at 3:54 am
I've moved what I would call the static folders before and yes theyre in registry keys in the sql instances hive. Why are you changing drive letters, why not retain...
July 6, 2015 at 3:52 am
if DB1, DB2 and DB3 aren't logically grouped then use separate groups for them. If theyre logically grouped, for instance all belonging to one application then use 1 ASO group.
July 6, 2015 at 3:49 am
Viewing 15 posts - 1,936 through 1,950 (of 9,253 total)