Viewing 15 posts - 2,701 through 2,715 (of 9,253 total)
plaid_draco (11/24/2014)
Jeffrey Williams 3188 (1/31/2012)
plaid_draco (1/31/2012)
Thank you for the quick responses! Very helpful.I guess my assumption that an active-active cluster would avoid that problem is unfounded. 😀
Second,...
November 25, 2014 at 3:22 am
Adam Bean (11/24/2014)
Ya got me again. Previously I was specifying the database, this time I was not. As soon as I specified the database, it indeed took me to 03.
:cool:...
November 24, 2014 at 8:01 am
Adam Bean (11/24/2014)
When I connect to the listener with ;ApplicationIntent=ReadOnly, it still lands on the current primary (which is SQL01\AO1):Shouldn't I have landed on SQL03 first?
Are you specifying the listener...
November 24, 2014 at 7:50 am
It doesnt get the server roles but i use this
SELECT'CREATE LOGIN [' + name + '] WITH PASSWORD = ' +
sys.fn_varbintohexstr(password_hash) +
' HASHED, SID = ' + sys.fn_varbintohexstr(sid) +...
November 24, 2014 at 7:47 am
Would check your replica names if i were you, seems you're using O and not 0 in some of the replica names and that's likely why it fails
ALTER AVAILABILITY GROUP...
November 24, 2014 at 7:38 am
assuming you're sorted now??
November 24, 2014 at 6:41 am
Firstly, why are you using a disk based quorum?
How many nodes are in the cluster?
Are they geographically dispersed?
To remove the quorum disk, reconfigure the quorum type with failover cluster manager...
November 24, 2014 at 3:51 am
HanShi (11/24/2014)
November 24, 2014 at 3:49 am
the sql server ntfs permissions are secured by the use of either local groups in ealier versions of windows or by virtual server accounts for Windows 2008 on. As the...
November 22, 2014 at 7:19 am
incidentally is this an iSCSI storage system or FC?
November 21, 2014 at 1:05 pm
PhilipC (8/7/2014)
Perry Whittle (8/7/2014)
November 21, 2014 at 12:55 pm
run them in same query window as that has the single connection
November 21, 2014 at 12:47 pm
Wayne West (11/21/2014)
Perry Whittle (11/21/2014)
If you're talking transparent database encryption then Exprsss edition is not going to provide this. It's an Enterprise feature only
I will not deploy Express for something...
November 21, 2014 at 10:16 am
are you running the restore within the same window as the prvious commands?
November 21, 2014 at 10:11 am
If you're talking transparent database encryption then Exprsss edition is not going to provide this. It's an Enterprise feature only
November 21, 2014 at 9:13 am
Viewing 15 posts - 2,701 through 2,715 (of 9,253 total)