Viewing 15 posts - 2,821 through 2,835 (of 9,244 total)
bbcolo22 (10/27/2014)
I am using Windows 2012R2.
Ok, Windows 2012 and 2012 R2 have a new feature called Dynamic Node Weight configuration. During a planned outage such as a shutdown the quorum...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" π
October 27, 2014 at 3:15 pm
bbcolo22 (10/27/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" π
October 27, 2014 at 2:09 pm
anthony.green (10/27/2014)
Traditional lettered drives I believe.I didn't set the cluster up from a Windows perspective.
You'd soon know when you run the installer by the free volumes offered and the shared...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" π
October 27, 2014 at 10:03 am
lsalih (10/27/2014)
Question for you, I know this is an old post but I was curious about where you have two different nodes (node1 and node2) and having two sql...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" π
October 27, 2014 at 9:02 am
are you using mounted volumes for your shared disks or traditional drive letter based volumes?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" π
October 27, 2014 at 8:59 am
rajeshjaiswalraj (10/27/2014)
My Instance was down i deleted model database file. I have .bak file. I tried to restore but its not working.
1. I connected single user...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" π
October 27, 2014 at 8:29 am
after a port change i would restart the listener using
ALTER AVAILABILITY GROUP group_name RESTART LISTENER βdns_nameβ
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" π
October 27, 2014 at 7:24 am
quackhandle1975 (10/27/2014)
Nice article, looking forward to the next in the stairway.qh
Here you go
http://www.sqlservercentral.com/articles/AlwaysOn/107537/[/url]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" π
October 27, 2014 at 7:15 am
ramana3327 (10/23/2014)
Is it possible to have AG created across multiple domains?
Are the domains in the same AD forest?
An always group is only supported across cluster boundaries for migration purposes only,
ramana3327...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" π
October 24, 2014 at 3:15 pm
ramana3327 (10/23/2014)
If there are 2 SQL Instances (Replicas) running on the same node, can they being part of the same AG?
No, all replicas in an always on group must...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" π
October 24, 2014 at 3:01 pm
if the services for both instances use the same account you shouldnt need to do anything, as the acct will be a sysadmin anyway
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" π
October 24, 2014 at 8:48 am
smtzac (10/24/2014)
Since I already have service account [SQL\SVC] created I DO NOT need this below step right??
is the same svc account being used for the sql server services on the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" π
October 24, 2014 at 5:23 am
domstrad (10/24/2014)
The SQL is mirrored without a witness serverHA is performed using VMotion
If you're mirroring the database then the HA is at the sql server level, introducing VMotion will...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" π
October 24, 2014 at 4:34 am
mlorek (10/23/2014)
Yes we have the funding we actually have a rather large budget and get a educational price break that is amazing.
Ok cool, just wanted to check. Most educational organisations...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" π
October 24, 2014 at 2:25 am
smtzac (10/23/2014)
---CREATE ENDPOINT <endpoint_mirroring>
STATE = STARTED
AS TCP ( LISTENER_PORT = 7023 )
FOR DATABASE_MIRRORING (ROLE=PARTNER)-----
If I run above script, I think,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" π
October 23, 2014 at 2:19 pm
Viewing 15 posts - 2,821 through 2,835 (of 9,244 total)