No announcements
Found 2911 threads
-
0 VotesState of Databases.
Hi Everyone, I have two database that are setup to working in a Mirroring mode, the first one is with the "Principal" state and the second one is on "Mirror, ...Proposed | 3 Replies | 1490 Views | Created by Diego Felipe Aquino - Monday, August 10, 2020 10:41 PM | Last reply by Cris Zhan - Monday, August 17, 2020 1:22 AM
-
0 Votes
[Announcement] SQL server related Forums will be migrated to a new home on Microsoft Q&A!
This SQL Server related Forum will be migrated to a new home on Microsoft Q&A! We’ve listened to your feedback on how we can enhance the ... -
0 Votes
Mirroring not stable on sql server 2016 always synchronizing
Hi all, I have 2 server and I configured database morring on sql server 2016. But performance not stable always from synchronized to ...Unanswered | 3 Replies | 2045 Views | Created by tith sineath - Monday, July 20, 2020 3:10 AM | Last reply by Cris Zhan - Friday, July 24, 2020 1:56 AM -
0 Votes
Database Mirroring Configuration
Hi team, I have two servers then I configured database mirroring on SQL Server database. But its performance is not stable.it always show status ...Unanswered | 2 Replies | 1805 Views | Created by Sokhoeung Huot - Monday, July 20, 2020 2:18 AM | Last reply by Cris Zhan - Friday, July 24, 2020 1:56 AM -
0 Votes
database Mirror Synchronizing
sqlserver database Mirror away SynchronizingProposed | 3 Replies | 1830 Views | Created by khann kosal - Monday, July 20, 2020 3:51 AM | Last reply by Cathy Ji - Wednesday, July 22, 2020 6:43 AM -
0 Votes
Error 1456 while connecting to witness
Hi all, I'm trying to add a WITNESS to my mirror instance. Mirrors are using SQL2012 Standart (WIN2012r2) and the witness is SQL2012 Express ...Answered | 5 Replies | 2129 Views | Created by Vatikk - Thursday, July 9, 2020 2:04 PM | Last reply by Cris Zhan - Monday, July 13, 2020 7:01 AM -
0 Votes
SQL Server 2019 - Unable to communicate with the runtime for 'R' script for request id:. Please check the requirements of 'R' runtime.
Environment Details: OS: Windows Server 2016 SQL: SQL Server 2019 + CU5 SQL Service and SQL Agent are ...Answered | 4 Replies | 3481 Views | Created by Prince Rastogi - Saturday, July 4, 2020 9:00 PM | Last reply by MIAOYUXI - Wednesday, July 8, 2020 1:22 AM -
0 Votes
Sysadmin permissions lost after mirroring failover.
SQL2012 . After databases failover to Secondary ( Database Mirroring ), Primary Server was restarted . While failback to Primary , observed that DBA group lost sysadmin ...Unanswered | 3 Replies | 2700 Views | Created by mallikha - Wednesday, June 17, 2020 5:44 PM | Last reply by Uri Dimant - Wednesday, July 1, 2020 7:02 AM -
0 Votes
Does SQL Server 2019 standard offer Active - Active configuration?
Does SQL Server 2019 standard offer Active - Active configuration? The intention is to use primary instance for application users and 2nd instance for reporting and ...Proposed | 2 Replies | 2692 Views | Created by Reddy KS - Saturday, May 30, 2020 5:32 PM | Last reply by Cris Zhan - Thursday, June 4, 2020 2:16 AM -
0 Votes
SQL Server 2012 will not mirror
We had a SQL 2012 Database on Windows Server 2008 and it was mirrored over to SQL 2012 on another Windows Server 2008. We upgrade the destination server to Windows server 2012. We ...Proposed | 2 Replies | 2600 Views | Created by DAvid Dobson - Tuesday, May 26, 2020 10:09 PM | Last reply by Cris Zhan - Wednesday, May 27, 2020 4:00 AM -
1 Votes
An error occurred in a Service Broker/Database Mirroring transport connection endpoint, Error: 8474, State: 11. (Near endpoint role: Target, far endpoint address: '')
Hi all, we are getting the below error where mirroring is configured in both the nodes in same time fraction of seconds difference. Every 12 hours we ...Answered | 4 Replies | 40783 Views | Created by chinna14 - Monday, May 11, 2015 5:49 PM | Last reply by Niels Grove-Rasmussen - Monday, May 25, 2020 6:54 AM -
0 Votes
Sql server 2016 Enterprise Licencing for mirroring or always On
Hello, I have one server with Sql server 2016 enterprise licenced. I want to create a mirroring or always On process with an other server. Does this ...Proposed | 5 Replies | 2989 Views | Created by Macc86 - Monday, May 18, 2020 1:50 PM | Last reply by Cathy Ji - Thursday, May 21, 2020 7:46 AM -
0 Votes
Migrating Mirroring instance to new server.
We are migrating Principle and Mirror SQL servers to newer version (2008 to 2016). New server and hardware in place along with SQL server. Now, we are in process of migrating databases from old ...Answered | 4 Replies | 3335 Views | Created by Chickoo79 - Wednesday, April 29, 2020 6:05 PM | Last reply by Chickoo79 - Thursday, April 30, 2020 2:17 PM -
0 Votes
Problem in Setting up Mirroring
Hi Friends, I am having small problem setting up the database mirroring. We do not have our server under any domains so I used certificate authentication to setup mirroring for other 2 databases. Now ...Answered | 7 Replies | 14242 Views | Created by Gopal425 - Tuesday, December 6, 2011 11:11 PM | Last reply by SNOOPY1979 - Monday, April 13, 2020 11:08 PM -
0 Votes
SQL 2019, problem with Transaction Log Shipping
Hi everyone, we have just upgrade our SQL servers to 2019 and I'm trying to establish Transaction Log Shipping (TrLS), to our backup server in DRL location. Until ...Answered | 4 Replies | 3066 Views | Created by AleksandarB - Thursday, April 9, 2020 11:58 AM | Last reply by MIAOYUXI - Friday, April 10, 2020 10:18 AM -
0 Votes
The Service Broker endpoint is in disabled or stopped state
Hi, We have 2 nodes SQL 2016 AG, laatly we get lots of messages on the primary node that syas: The Service Broker endpoint is in disabled or ...Proposed | 6 Replies | 5423 Views | Created by Shahin - Wednesday, March 25, 2020 11:47 AM | Last reply by Dawn Young - Wednesday, April 1, 2020 6:40 AM -
0 Votes
SQL database replicating from multiple principles to a client
Hi there, I will like to get advices if the following scenario will work out and what is the possible solutions. I am looking at some SQL databases HA solution where ...Proposed | 3 Replies | 2879 Views | Created by ToshYeo - Wednesday, March 25, 2020 3:05 AM | Last reply by ToshYeo - Monday, March 30, 2020 8:19 AM -
3 Votes
SQL Server Agent fails to connect to DB after enabling mirror on failover cluster
Hello: We have multiple databases running in a Failover Cluster instance: SQL 2012SP1 on Server 2008 R2 failover cluster (NOT AlwaysOn). We are trying to add a high-performance ...Answered | 4 Replies | 9163 Views | Created by Mr. Joe M. _ - Monday, June 30, 2014 5:52 PM | Last reply by Forch - Sunday, March 29, 2020 4:08 PM -
0 Votes
AG sync issue
HI, We having an issue with our SQL 2016 AG. Our 2 nodes AG first was in asynchronous mode and we had to change it to synchronous mode. But becaus the Database is large it ...Proposed | 10 Replies | 3431 Views | Created by Shahin - Friday, February 28, 2020 2:00 PM | Last reply by Cathy Ji - Friday, March 6, 2020 8:02 AM -
0 Votes
changing AG mode issue
Hi Guys, We having a problem with changing the AG 2016 mode from ASYNCHRONOUS to SYNCHRONOUS mode. When changing the mode get this message in the ...Proposed | 10 Replies | 3425 Views | Created by Shahin - Wednesday, February 19, 2020 11:06 AM | Last reply by Cathy Ji - Friday, February 28, 2020 9:57 AM - Items 1 to 20 of 2911 Next ›
No announcements
