Questions tagged [mirroring]

For questions about database mirroring - a technology used to create and maintain an exact copy of a database, synchronously or asynchronously.

Filter by
Sorted by
Tagged with
0 votes
0 answers
29 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 ...
Lamija37's user avatar
0 votes
2 answers
75 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)?.
ganesh malusare's user avatar
0 votes
1 answer
63 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 ...
SE1986's user avatar
  • 1,960
0 votes
1 answer
52 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 ...
Pivigor's user avatar
0 votes
2 answers
85 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 ...
Farhan's user avatar
  • 121
0 votes
0 answers
38 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 ...
Aheho's user avatar
  • 141
0 votes
0 answers
87 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 ...
Brian Karabinchak's user avatar
0 votes
0 answers
1k 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: '...
kumar's user avatar
  • 161
0 votes
1 answer
584 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 ...
Brian Karabinchak's user avatar
0 votes
1 answer
142 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 ...
Sven Dühring's user avatar
0 votes
1 answer
603 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 +-------------+--------------------------------------+-----------------+----------------------+-----...
Fajela Tajkiya's user avatar
0 votes
1 answer
110 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 ...
user245321's user avatar
0 votes
2 answers
866 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 ...
user1186050's user avatar
0 votes
1 answer
140 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 ...
user avatar
1 vote
0 answers
55 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 ...
user3766600's user avatar
2 votes
0 answers
46 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 &...
tim's user avatar
  • 21
0 votes
1 answer
173 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 ...
Stockburn's user avatar
  • 429
0 votes
2 answers
183 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 ...
PTL_SQL's user avatar
  • 325
2 votes
2 answers
139 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....
Tom's user avatar
  • 21
2 votes
1 answer
178 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 ...
Aaron's user avatar
  • 1,771
0 votes
1 answer
930 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 ...
sqllover2020's user avatar
0 votes
1 answer
96 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 ...
spyla's user avatar
  • 1
0 votes
1 answer
942 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 ...
Rauf Asadov's user avatar
  • 1,253
0 votes
1 answer
119 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 ...
Gnudiff's user avatar
  • 141
0 votes
0 answers
44 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 ...
Ahmet Arslan's user avatar
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 ...
Aditya Nair's user avatar
4 votes
1 answer
1k 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 ...
BeginnerDBA's user avatar
  • 2,169
1 vote
0 answers
149 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 ...
user3071284's user avatar
-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 ...
Muhammed Salah Ud Din Manzoor's user avatar
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 ...
SE1986's user avatar
  • 1,960
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 ...
Battlefury's user avatar
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 ...
Lucas Rasolofoniaina's user avatar
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 ...
Guillaume Filion's user avatar
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 ...
SE1986's user avatar
  • 1,960
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 ...
Marcello Miorelli's user avatar
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 ...
Leonardo Lacerda's user avatar
0 votes
2 answers
545 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 ...
Molenpad's user avatar
  • 1,784
1 vote
1 answer
753 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 ...
HARI VARMA's user avatar
4 votes
1 answer
655 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 ...
Bill Matson's user avatar
0 votes
2 answers
290 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 ...
vay's user avatar
  • 19
0 votes
1 answer
68 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 ...
dotnetavalanche's user avatar
2 votes
2 answers
623 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-...
Brian B's user avatar
  • 23
1 vote
1 answer
156 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 ...
SE1986's user avatar
  • 1,960
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 ...
dotnetavalanche's user avatar
0 votes
0 answers
134 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 ...
TheDataGuy's user avatar
  • 1,920
0 votes
3 answers
366 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-...
TheLast10sat's user avatar
1 vote
0 answers
733 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 ...
ChrisK's user avatar
  • 43
1 vote
1 answer
62 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 ...
SE1986's user avatar
  • 1,960
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 ...
TheDataGuy's user avatar
  • 1,920
1 vote
0 answers
299 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 ...
BeginnerDBA's user avatar
  • 2,169

1
2 3 4 5
8