Questions tagged [mirroring]
For questions about database mirroring - a technology used to create and maintain an exact copy of a database, synchronously or asynchronously.
364
questions
0
votes
1
answer
39
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 ...
- 1,908
0
votes
1
answer
35
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 ...
- 1
0
votes
2
answers
54
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
30
views
Prevent Sql Server sending Failover partner to connecting clients
I have 2 Sql Server 2008R2, enterprise edition servers setup in an asynchronous (High Peformance) mirror setup. There is no witness.
Intermittently I find that a client will attempt to connect to the ...
- 141
0
votes
0
answers
82
views
Cannot setup witness for mirroring in SQL Server, alter database command could not be sent?
Using SQL Server 2019. I setup certificates, users and logins for a principal/mirror/witness for 3 SQL Servers that are on 3 separate VM's all on the same ESXI server.
I have the prinicipal and ...
0
votes
0
answers
975
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: '...
- 161
0
votes
0
answers
130
views
SQL Server mirroring keeps breaking, unsure why?
I have 3 VM's running on a single ESXi server with the following setup
Operator Station (OS) - 192.168.44.211
Engineering Station (ES) - 192.168.44.212
Witness VM - 192.168.44.213
The OS and ES are ...
0
votes
1
answer
422
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
117
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
486
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,159
0
votes
1
answer
100
views
SQL Mirroring Witness server Corrupted
The witness server on my environment is corrupted and the mirrored database failed over to the secondary server. I removed database from Principal server, hoping that I can set up mirroring between ...
- 11
0
votes
2
answers
720
views
In Azure, what's the best setup for creating a development db with a production db? Replication, mirroring, copying, copy then sync, etc?
Currently in Azure, I have a website (app service) pointing a database (Sql Server). So far so good! Everything is still in development so nothing is live yet. I use EF code first migration with all ...
0
votes
1
answer
137
views
SQL Server 2014 mirroring Backup
Is it necessary to stop working on the database when preparing the mirroring process?
If I take an old backup of the main database and restore it, will all the new data be transferred when running ...
Max Sh
1
vote
0
answers
48
views
mysql mirroring
I have 2 mysql server 5.6.34 running, one on aws RDS other locally. Is it possible to set up mirroring from RDS to local one? I know that later version like 8 support replication and mirroring via ...
- 11
2
votes
0
answers
45
views
Can't delete secondary mirror DB stuck in (Mirror, Disconnected / In Recovery) [duplicate]
i'm facing an issue with a corrupted secondary database on SQL Server 2016. After a massive outage we were able to restore most of the databases immediately without issues. Two databases were in the &...
- 21
0
votes
1
answer
134
views
SQL Mirroring Replace Certificates
I have inherited two SQL 2016 servers with two mirrored databases.
They have been built with certificates as they are in a workgroup, the certs expire in six months. I am trying to understand the ...
- 429
0
votes
2
answers
172
views
Why choose SQL FCI over Database Mirroring
I have SQL 2016 Standard Edition to install and configure a HA/DR solution. I need automatic failover in a cluster of two nodes. I am proposing SQL FCI over database Mirroring for the following ...
- 303
2
votes
2
answers
135
views
In a mirror, how can I keep the SQL Server Agent offline, but have it start automatically in the event of a failover on the Principal?
In this scenario there are three MS SQL servers. ServerA has a series of jobs that write data to databases on ServerB. I want to set up ServerC as a mirror of ServerA, with all the same jobs available....
- 21
2
votes
1
answer
161
views
Jobs on the Mirror are running against the Primary
I have a mirrored set of jobs between the my current primary and mirrored failover SQL Server setup. In the past, the jobs on the mirrored server, when they are enabled, fail as they are not able to ...
- 1,771
0
votes
1
answer
870
views
Always On Instance Service Broker/Database Mirroring transport connection endpoint Error
I have a production instance that has 2 AOG. There is no mirroring configured for both groups. Both groups are also in 'Healthy' state.
Upon checking the error log on SQL Server, I noticed that ...
- 83
0
votes
1
answer
87
views
can you setup replication on mirrored SQL database
Just moved to SQL2017 Ent. Currently, do transactional replication for 1.5TB DB. the replicated database is used for data analytics, mainly Power BI reports. Need near real-time data. When I have ...
- 1
0
votes
1
answer
896
views
log_reuse_wait_desc - AVAILABILITY_REPLICA Unable to truncate transaction log
I have just 1 secondary replica and just one database in my availability group. Both Primary and Secondary replicas are in synchronous-commit availability mode. I inserted 1000 records into the table ...
- 1,253
0
votes
1
answer
104
views
Maintaining Postgres copies of fdw tables from Oracle
I have a production Oracle 11g server, from which I want to copy data regularly to PostgreSQL 10.14 database for DWH uses, so as not to overload the production with analytics queries.
I have ...
- 141
0
votes
0
answers
43
views
Oracle DB Replication/Data Transfer
I need to replicate an oracle database without updating each other just for backup purposes.
I have a Main DB(MDB) that have jobs to send to be processed data to interface DB(IDB). IDB will be ...
- 101
0
votes
1
answer
1k
views
Database stuck in synchronized mode and another one in 'Initializing / In Recovery' mode
I have a database which is stuck in Synchronized mode and another database in Initializing / In Recovery mode. Both of them have been removed from their availability groups and I cannot even delete ...
- 101
4
votes
1
answer
981
views
Compatibility mode change does not reflect on secondaries
I was of belief that changing compatibility mode on primary database in database mirroring would make the change for mirror database.
But it proved to be wrong. I queried using sys.databases on ...
- 2,169
1
vote
0
answers
138
views
Keep 2 instances of SQL Server synced [closed]
We want to set up a second instance/server of SQL Server such that both instances will be kept in sync. The reason is we need to separate some users and processes out to a separate server for business ...
- 111
-1
votes
1
answer
43
views
Microsoft SQL Server Database Miroring
I have few questions about Microsoft SQL Server database Mirroring.
Fail over of database is Automatic or Manual in case of Microsoft SQL database mirroring?
In case of failure in Primary database ...
2
votes
1
answer
3k
views
Does Traceflag 1800 require a restart?
We have recently migrated our database mirroring secondary to new hardware. The log drive (and other SQL Server drives) on the secondary has been formatted to 64KB block size, whereas the primary ...
- 1,908
0
votes
1
answer
56
views
How to have a fail-over resilient SQL Server view over linked mirrored database table
Say I have a set of servers with mirrored application databases and a set of statistics servers where a couple of the tables are exposed from the application database as views (with some tenant ...
- 103
0
votes
1
answer
2k
views
Mirroring sql server , how to change the port?
I have two servers on the same cluster, in fact my goal is to set up "high availability", but the databases that I have integrated are not synchronized, so I think it is " mirroring "that I created ...
0
votes
0
answers
57
views
SQL Server Mirroring Many DBs
We have two identical servers running SQL Server 2017.
Let's call them A and B. A is hosting 12 databases and B is hosting 6 databases.
Each server is synchronously mirroring its DBs on the other ...
- 101
1
vote
1
answer
28
views
Database Mirroring - Will forcing the service only lose non-committed data?
I have a database mirroring session in high safety mode between Server1 (Primary) and Server2 (Secondary)
According to this, synchronous data mirroring means
every transaction committed on the ...
- 1,908
1
vote
0
answers
1k
views
database mirror - A connection attempt failed because the connected party did not properly respond after a period of time
I have database mirror set up in one of my servers and all seems to be fine, however, from time to time I get this error message in the logs:
--Execute it on Primary/Secondary server
EXEC ...
- 15.8k
1
vote
3
answers
3k
views
Database Mirror - Host can not be reached or does not exist
I tried mirroring database with GUI and T-SQL, but I had problems in both cases.
Here is some information about infrastructure and SSMS:
INFRASTRUCTURE
Principal server with SQL Server 2017 ...
- 314
0
votes
2
answers
524
views
How does pausing a SQL Server mirror affect transaction logs on the principal?
One of our two datacenter's is undergoing maintenance for a minimum of 72 hours, but it could be up to 5 days, and I have a very old legacy SQL Server running a production service as a mirror across ...
- 1,774
1
vote
1
answer
688
views
launch database mirroring monitor grayed out in SQL server 2014
I have 2 servers configured with mirroring each other. Both the servers are principal & Mirror servers each other. From the 2nd Server launch database mirroring monitor is working fine but from ...
- 31
4
votes
1
answer
641
views
Temporarily disable SQL Server Mirroring
We've got a migration going on where a SQL Server 2012 mirroring configuration running in high safety with auto failover (primary/mirror/witness) is being completely shut down and restarted to move ...
- 41
0
votes
2
answers
281
views
SQL Server effectiveness of mirroring partial database
Our database stores 200 TB of data. We've setup clustering options of two VM nodes with one storage but due to limited resources, we cannot replicate the entire database for disaster recovery (only ...
- 9
0
votes
1
answer
66
views
Moving SQL server 2016 DB's from mirroring to HA
We have Windows Server 2016 machines with SQL server 2016 standard edition. Currently mirroring is implemented and now are planning to move to HA with 1 listener for each DB. We have multiple DB's
...
- 123
2
votes
2
answers
588
views
Log file won't shrink - suggestions?
I have a 225GB DB with a 390GB log file, which has only recently exploded in size. I am trying to shrink it - per these instructions: https://www.brentozar.com/blitz/transaction-log-larger-than-data-...
- 23
1
vote
1
answer
151
views
TFS Installation Fails over to mirroring secondary despite not having a Fail-over partner specified
We have TFS Version 15.105.27412.0 installed on a server (Server A) and have it configured to point at our database server (Server B).
We have the two TFS databases (tfs_defaultcollection and ...
- 1,908
1
vote
0
answers
28
views
Impact of changing server machines names with SQL Server 2016 Standard in mirror state
It's an enterprise network domain.
Two existing Windows server 2016 machines, one each for SQL Server 2016 Standard edition and other is also SQL Server 2016 Standard edition in a passive mirror ...
- 123
0
votes
0
answers
130
views
SQL Server - Mirroring from 2014 to 2017 check unsent log status
I configured SQL Server Mirroring from SQL server 2014 standard to SQL Server 2017 Enterprise.
Steps I followed:
Create an endpoint on both servers with certificate authentication.
Dump and ...
- 1,910
0
votes
3
answers
361
views
MSSQL Mirroring + db integrity check
Is it necessary to do a database integrity check (DBCC check) on mirrored databases?
https://learn.microsoft.com/en-us/sql/sql-server/failover-clusters/automatic-page-repair-availability-groups-...
1
vote
0
answers
721
views
Transaction Log File corruption on Mirror server SQL 2017
Wondering if anyone has encountered database transaction log file corruption when database mirroring is enabled in SQL 2017 running on Windows Server 2019, on the Mirror server?
If so, curious what ...
- 43
1
vote
1
answer
60
views
Datetime columns in sys.dm_db_mirroring_connections are an hour behind
I have database mirroring set up on my SQL Server instance.
If I run SELECT * FROM sys.dm_db_mirroring_connections I get information about the mirroring connections, however, all the time columns in ...
- 1,908
0
votes
0
answers
69
views
SQL Mirroring - Application not pointing to new Primary
Im stuck with a connection string issue
this is my connection string.
<add name="APP01" connectionString="Server=10.169.0.2; Failover Partner=10.166.0.2; Initial Catalog=DB2017; Integrated ...
- 1,910
1
vote
0
answers
288
views
Stuck Oldest unsent transaction in db mirroring [closed]
I am seeing some very strange behavior in db mirroring
For one of the databases, during the weekend when rebuild index job ran on the principal, it generated around 60 GB log.
Now its been 2 days ...
- 2,169
0
votes
1
answer
217
views
Postgres - 2 database mirror
I have 1 DB called - DB_A. I would like to create read only database DB_B from DB_A which updates itself every 10 mins. Is their any easy way to do it in postgres? I am using Postgres 11. Also any ...
- 1