Questions tagged [mirroring]
For questions about database mirroring - a technology used to create and maintain an exact copy of a database, synchronously or asynchronously.
368 questions
0
votes
1
answer
70
views
ADO.NET client occasionally attempts connection to SQL Server mirror partner even when principal is online
We're running SQL Server 2016 Standard Edition with database mirroring in synchronous mode and automatic failover enabled. Our .NET applications use connection strings with Failover Partner.
...
- 1
0
votes
2
answers
95
views
MSSQL Server Mirroring One Master Two Slave Architecture
Is there is any procedure to do MSSQL Mirroring with single master and multiple slave.
two slave X one master
Or this one.
One Master X One Slave for Viewing only
I need a MS SQL server for viewing ...
2
votes
1
answer
211
views
Do Basic Availability Groups have any benefits not found with Database Mirroring?
Assuming SQL Server 2022 Standard Edition on Windows, I simply cannot see any benefits to using Basic Availability Groups instead of Database Mirroring. Is there anything offered by Basic Availability ...
- 1,288
-1
votes
1
answer
143
views
Connection String with Multisbunetfailover=true fails. States mirrored SQL Server Instance not supported
I have two SQL servers configured with an availability group. The configurations uses a dnn for it's listener. Connection tests to the configured port are successful.
When we try to make a connection ...
- 99
0
votes
1
answer
318
views
SQL Server 2019 Mirroring Server Network Address Cannot Be Reached
I am trying to setup mirroring between two servers with separate sql server instances but every time I have received an error message with the following details:
An error occurred while starting ...
- 1
0
votes
1
answer
412
views
Synchronizing two databases on different servers
I have two databases on different servers. Each one of them contains 350+ tables and users have read and write access on both databases.
I want to synchronize them, but in special cases, like if a ...
- 101
0
votes
0
answers
46
views
SQL Server database migration issues
I have a system with two servers and three client workstations. Servers were configured to work as principal/mirror servers (mirroring was configured with certificates). I have two databases in SQL ...
- 1
0
votes
2
answers
528
views
MS SQL DB server 2019: Async Mirroring(High-Performance) is Available in standard edition(2019)?
MS SQL DB server 2019: Async Mirroring(High-Performance) is available only in the enterprise edition(2019). or also Available in standard edition(2019)?.
1
vote
1
answer
1k
views
Database Mirroring - Failed Logins on primary after failover
We have a Database Mirroring setup between PROD and SECONDARY and we have failed over to the secondary replica (SECONDARY) . We are now getting a number of almost constant failed logins showing in the ...
- 2,264
1
vote
1
answer
211
views
Redirecting and converting MySQL queries to Postgres on the server side
The first thing I would like to say is that I'm not going to build a production on such an architecture. I am interested purely for the sake of experiments in home experiments and performance in the ...
- 11
0
votes
2
answers
251
views
SQL Server standard circular replication
As far as i know, SQL Server standard edition supports only 1 mater and other becomes its replica, like Master---> Slave mirroring or replication,
Does it also supports Circular replication? like ...
- 121
0
votes
0
answers
2k
views
Database Mirroring login attempt failed with error: 'Connection handshake failed. An OS call failed:(8009030c) 0x8009030c(The logon attempt failed)
In SQL server 2016 instance, Database Mirroring went to disconnected state due to below error. The below error logged in sql server error log.
Database Mirroring login attempt failed with error: '...
- 171
0
votes
1
answer
2k
views
Mirror database stuck in Restoring... state?
I just setup mirroring between a principal and mirror server. I am following some steps a coworker left for me as I have not done this before.
At one point, I had to backup the principal database ...
0
votes
1
answer
205
views
Is it possible to have a failover sql server with same instance name and same database name?
We have an application that is licensed on MS sql server instance name and database name. It is not possible to add a second instance/database. Is it possible to have active mirroring and let the ...
0
votes
1
answer
1k
views
How to failover in a database mirroring session when the safety mode is off and no witness
I'm testing SQL Server database mirroring and below is my topology.
node2, principal
node1, mirror
+-------------+--------------------------------------+-----------------+----------------------+------...
- 1,239