Viewing 15 posts - 2,821 through 2,835 (of 9,241 total)
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
before you even consider alwayson groups do you actually have the appropriate windows server and sql server licences?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 23, 2014 at 11:37 am
another newbie (10/23/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 23, 2014 at 9:45 am
i'd love to help more but it's not entriely clear what your issue is
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 23, 2014 at 9:38 am
Viewing 15 posts - 2,821 through 2,835 (of 9,241 total)