Viewing 15 posts - 31 through 45 (of 1,080 total)
June 19, 2018 at 2:29 am
1) Even after 3) there still isn't a usable database because "mydatabase" on S2 (which had become the primary) could've had transactions on it that S1 doesn't know about yet?
June 18, 2018 at 11:02 pm
Firstly, speakers invest a lot of their own time, mostly unpaid to give back to the community, and anyone who fails to appreciate this should stop attending sessions.
June 18, 2018 at 12:16 am
Start with Perry's Stairway to AlwaysOn, will answer all your questions: http://www.sqlservercentral.com/stairway/112556/
February 19, 2018 at 1:14 am
Try the following. I set @myvalue to 6 as a test for a normal operation. Comment it out and you'll get a "-3" returned.
Build your other logic around/in it.
November 2, 2017 at 1:19 pm
November 2, 2017 at 10:28 am
November 2, 2017 at 8:52 am
Since the Quorum and FSW is a Windows Cluster Component, your best bet is PowerShell:
get-clusterresource -cluster sqlcluster | where-object {$_.ResourceType -like “File Share Witness”} | get-clusterparameter
To...
November 2, 2017 at 8:16 am
November 2, 2017 at 7:52 am
If I understand your question correct, you should use ALTER AVAILABILITY GROUP:
October 30, 2017 at 7:13 am
October 27, 2017 at 10:24 am
From your post, we can understand that:
1. Your Infrastructure Team wants a Failover Cluster with a FSW Quorum instead of shared Disk,
2. SQL DB Mirroring uses a Witness...
October 27, 2017 at 10:14 am
October 17, 2017 at 7:28 am
October 17, 2017 at 6:23 am
Consider using the ReadOnlyRouting and the ApplicationIntent=ReadOnly switch in your connection string for the read-only readers.
October 9, 2017 at 6:26 am
Viewing 15 posts - 31 through 45 (of 1,080 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy