No announcements
Found 1877915 threads
-
0 VotesAlways On - Read only replica
You dont pay if it is purely use only as stand-by server.Answered | 3 Replies | 1012 Views | Created by DoronB80 - Monday, February 23, 2015 4:05 PM | Last reply by Ashwin Menon - Monday, February 23, 2015 4:41 PM
-
0 Votes
Always on read only distribution
To clarify the Point (just because I needed to read it twice to get it...)Answered | 2 Replies | 2203 Views | Created by Mjmalatek - Monday, July 15, 2013 7:16 PM | Last reply by PrinceLucifer - Tuesday, July 16, 2013 5:52 AM -
1 Votes
SQL 2017 Always On High Availability cannot connect to read-only replica
Used the following instructions to try and setup for the secondary replica to be read-only through the listener.Answered | 2 Replies | 1030 Views | Created by Lithuanian98 - Tuesday, March 17, 2020 4:42 PM | Last reply by Lithuanian98 - Tuesday, March 17, 2020 8:18 PM -
2 Votes
Multi-subnet AG and read-only replicas
It works provided that you meet the following requirements SQL Server Native Client 11 or higherData Provider for SQL Server in .NET Framework 4.02 or higherMicrosoft JDBC ...Answered | 2 Replies | 1036 Views | Created by peterfeakins - Wednesday, June 29, 2016 12:23 AM | Last reply by Edwin M Sarmiento - Wednesday, June 29, 2016 4:20 AM -
0 Votes
Always on availability group replica will not sync
Use the Always On Availability Group dashboard.Answered | 3 Replies | 1137 Views | Created by juniorkiran - Wednesday, January 15, 2020 7:37 AM | Last reply by Cathy Ji - Thursday, January 16, 2020 7:12 AM -
1 Votes
Connect To A Specific Secondary Read-Only Replica Among Multiple
As listener always points to Primary replica. so your only option is directly connecting to the secondary replica.Answered | 2 Replies | 781 Views | Created by Sohi420 - Friday, May 18, 2018 12:08 AM | Last reply by Kumar muppa - Friday, May 18, 2018 12:43 AM -
0 Votes
Read Only SQL 2012 Replica DB on a SQL 2014 box
Secondary replicas on a higher database engine version are never readable, because the database would need to be upgraded, and then wouldn't be a replica of the primary.Answered | 4 Replies | 1272 Views | Created by Plip71 - Wednesday, April 16, 2014 1:07 PM | Last reply by Plip71 - Friday, April 18, 2014 9:30 AM -
0 Votes
Are DDL Changes sent to Always on secondary replica?
We would like to use always on for read only secondary replicas to offload read only application activity.Answered | 1 Replies | 993 Views | Created by DBAFan2013 - Wednesday, May 11, 2016 7:29 PM | Last reply by Hilary Cotter - Wednesday, May 11, 2016 8:31 PM -
0 Votes
Intellisense causing blocking on read only AlwaysOn replica
This morning whilst a support analyst was connected to a read only AlwaysOn replica, intellisense in SSMS 2012 started blocking a process on the primary which was attempting ...Answered | 1 Replies | 1595 Views | Created by DBADale - Friday, February 21, 2014 8:44 AM | Last reply by Kalman Toth - Saturday, February 22, 2014 9:50 AM -
0 Votes
Always on replica not failover automatically to secondary replica
Hi If AlwaysON is configured with automatic failover then the databases in the Availability groups have to be in synchronized mode and not in synchoinizing mode because for ...Answered | 1 Replies | 1509 Views | Created by TwoR - Monday, November 18, 2013 2:47 PM | Last reply by Alankar Chakravorty - Monday, November 18, 2013 5:42 PM -
0 Votes
Table triggers on a read-only secondary replica - How do they behave?
I also found the thread https://social.msdn.microsoft.com/Forums/sqlserver/en-US/baa3a03a-2fca-4262-ac5f-680e5354f3fe/dml-triggers-behaviour-on-secondary-replica?Answered | 2 Replies | 1908 Views | Created by ShahriarA - Tuesday, June 30, 2015 8:37 AM | Last reply by ShahriarA - Tuesday, June 30, 2015 2:30 PM -
1 Votes
AlwaysOn - Targetting a Read-Only Replica with Linked Servers and SSMS
Although troubleshooting read-only routing is complicated by the client's refusal to fail when failing to connect to the indicated replica.Answered | 12 Replies | 2500 Views | Created by David Weingarten - Tuesday, July 29, 2014 2:33 PM | Last reply by David Weingarten - Thursday, July 31, 2014 1:23 PM -
0 Votes
Distributing read load balance with always on
Unfortunately, read-only routing does not do load balancing.Answered | 1 Replies | 847 Views | Created by UKRobD - Thursday, July 30, 2015 8:19 AM | Last reply by Edwin M Sarmiento - Thursday, July 30, 2015 6:04 PM -
4 Votes
Datasheet view is always read-only
(Moderator) P.S The above applies always.Answered | 15 Replies | 70584 Views | Created by JXJ - Wednesday, July 18, 2007 2:13 AM | Last reply by Mandar GM - Wednesday, January 11, 2012 10:07 AM -
0 Votes
log backup on secondary replicas (always on)
One more question, does the statistics information also be maintained on the secodary replica?Answered | 2 Replies | 1571 Views | Created by smileahpu - Tuesday, April 15, 2014 7:48 AM | Last reply by smileahpu - Wednesday, April 16, 2014 2:39 AM -
0 Votes
Read Only Routing
Next, for each readable secondary replica that is to support read-only routing, you need to specify a ...Answered | 2 Replies | 921 Views | Created by Cornelius_RE - Monday, December 24, 2018 5:10 PM | Last reply by Emily Fei - Tuesday, December 25, 2018 3:01 AM -
0 Votes
SQL Server 2014 Always ON - Secondary Replica Application Intent Apply READ_WRITE
They are not available for read access.Answered | 1 Replies | 1211 Views | Created by douglas foong - Tuesday, February 10, 2015 9:30 AM | Last reply by Lydia Zhang - Wednesday, February 11, 2015 5:59 AM -
0 Votes
Can high CPU on secondary replica effect the primary replica in synchronous Always on AG?
If the cpu usage of the secondary replica is 100%, there is no extra thread to perform the harden task, which will inevitably affect the primary ...Answered | 2 Replies | 1362 Views | Created by Asif_DBA - Sunday, September 8, 2019 12:25 PM | Last reply by Dedmon Dai - Monday, September 9, 2019 9:21 AM -
1 Votes
sharepoint 2010 readable secondary replicas sql server 2012 always on
2 SharePoint servers installed as independent farms on 2 sql servers that are joined as replicas in an Always On configuration.Answered | 22 Replies | 3886 Views | Created by jonnly - Monday, September 30, 2013 8:09 PM | Last reply by John07689 - Friday, July 13, 2018 2:53 PM -
0 Votes
Just noticed always creating database as read-only?
Hi, It can't just go read-only on its own.Answered | 4 Replies | 1832 Views | Created by T J - Tuesday, April 23, 2013 2:42 PM | Last reply by Saurabh Sinha DBA - Tuesday, April 23, 2013 7:00 PM - Items 1 to 20 of 1877915 Next ›
No announcements
