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
1
vote
0answers
19 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 ...
1
vote
0answers
48 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 ...
-1
votes
1answer
33 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 ...
0
votes
1answer
69 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 ...
0
votes
1answer
20 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 ...
0
votes
1answer
38 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
0answers
44 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 ...
1
vote
1answer
14 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
vote
0answers
173 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 ...
0
votes
3answers
164 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 ...
0
votes
0answers
22 views

What is the simplest method to get a Readable Copy of the database, one having more historic data

I am hoping to get some input as to what the best replication method/tool would be for my situation. I have to make a new system and the business needs are as follows : They need to have access to ...
0
votes
2answers
62 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 ...
0
votes
1answer
117 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 ...
4
votes
1answer
88 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 ...
0
votes
2answers
36 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 ...
0
votes
1answer
35 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 ...
2
votes
2answers
87 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-...
1
vote
1answer
90 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
vote
0answers
21 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 ...
0
votes
0answers
56 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 ...
0
votes
3answers
159 views

MSSQL Mirroring + db integrity check

Is it necessary to do a database integrity check (DBCC check) on mirrored databases? https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/automatic-page-repair-availability-groups-...
1
vote
0answers
247 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 ...
1
vote
1answer
35 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 ...
0
votes
0answers
27 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
vote
0answers
158 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 ...
0
votes
1answer
45 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 ...
2
votes
1answer
276 views

SQL Server Mirror: Witness Server(s)

Inherited a new SQL estate that has never been touched by a full time DBA. Mirroring has been setup and removed on multiple servers but not fully, old witness servers are still active. Is there ...
1
vote
1answer
274 views

Mirroring issue with mirror server

I am running two Windows Servers 2012 R2 with SQL Server 2014 Standard Edition. I have strange issue on mirroring. I configured mirroring on for 15 databases, no Witness server. The Principal server ...
1
vote
1answer
119 views

Trace Flag impact to Mirrored Databases

I want to enable dead lock trace flag -t1222 on a production SQL Server 2014 instance. Many databases on this instance are configured with database mirroring. What (if any) impact to mirrored ...
1
vote
1answer
134 views

is there a way (clean or unclean) to eliminate a filestream data file on a production SQL Server database?

Is there a way (clean or unclean) to eliminate a filestream data file on a production database? I forced a garbage collection on an empty filestream : sp_filestream_force_garbage_collection @dbname =...
0
votes
1answer
189 views

How do I configure my SQL Server instance to use a different Edition with minimal side effects?

I'm in the process of migrating an old server running Windows 2008 R2 with SQL 2012 Express to a new server running SQL Server 2017 Standard and Windows 2016. I would like to mirror databases between ...
1
vote
1answer
57 views

SQL Server 2012 Transaction Log needed to create database mirror?

There's a somewhat lengthy discussion of Transaction Logs in Microsoft's instructions for setting up a database mirror. We've never bothered with Transaction Logs in the past; do we really need to ...
2
votes
3answers
544 views

Transaction log filling the drive if mirroring fails

I am having two SQL Server 2016 machines with mirroring set up. This is supposed to be hot-standby scheme. HDD size is 1TB, and database size is around 600GB (just one DB). This is 90 days worth of ...
1
vote
0answers
21 views

How I can truncate and shrink the Logs file in mirroring (Full Recovery model)?

I am trying to truncate and shrink the database. I have taken the backup of transaction logs and now trying to shrink but it's executing with No effect. I have used dbcc shrinkfile(). Please help
1
vote
0answers
51 views

SQL Mirroring Message “The mirroring connection to ”address“ has timed out for database ”database"

Executing under SQL Server 2016 SP2 (SP2-CU2-GDR) (KB4458621) enterprise edition. Receiving error message "The mirroring connection to "address" has timed out for database". Do not have a witness ...
0
votes
1answer
26 views

Mirroring and logs [closed]

we have mirroring on our live database and we will updating live hardware. I will be failing over to our DR box. Do I need to stop mirroring AFTER failing over, or do I let it continue checking for ...
1
vote
1answer
271 views

service broker with mirroring

After we tried configure a database with service broker into an always on environment and failed (the service broker is not working properly) we are now considering to try mirroring for high ...
2
votes
0answers
58 views

Mirrored TDE DB Performance

Performing a large index reorg on a mirrored SQL Server 2014 TDE database creates a large redo log on the mirror and the mirroring monitor displays an infinite restore time. The exact same process ...
2
votes
1answer
512 views

Database Mirroring failover with CNAME

I have SERVERA and SERVERB configured for Database Mirroring starting with A as Principal and B as Mirror. I created a CNAME for SERVERA and use that in my connection string. I am not using the ...
1
vote
0answers
144 views

Waiting Tasks on Mirror

I just migrated my primary's synchronous mirror to a new server and I've noticed that there are 150 to 230 waiting tasks on the mirrored instance (based on the activity monitor.) I don't recall if ...
1
vote
1answer
416 views

Mirroring on-premise SQL Server to AWS EC2 SQL Server

Trying to mirror an on-premise SQL Server instance to EC2 instance, but not much information is available on this topic. The closest one I managed to find is: Implement SQL Server High Availability ...
2
votes
1answer
491 views

MSSQL Mirroring equivalent to Oracle Data Guard Snapshot Standby

Does MSSQL support an operating mode on the failover partner / mirror that is functionally equivalent to Oracle database's Snapshot Standby mode? ie A temporary active copy of the replicated ...
2
votes
1answer
675 views

SQL Server Migration using a DB Mirror (Rolling upgrade)

I'm planning to do SQL Server migration of SQL Server 2012 to a new hardware and a new version of SQL Server (2016). I'm trying to find the best solution with minimal downtime. I found some ...
0
votes
1answer
53 views

Database organization for mirroring / partitioning / multistore [closed]

I know that is kind of generic question, but there is not other way to find a good answer. I have a requirement to create a network of a server and few simple PCs. My boss wants to have the database ...
2
votes
1answer
1k views

Error 1456 when trying to SET a Witness using TSQL

Trying to run the following command: ALTER DATABASE myDB SET WITNESS = 'TCP://myServer.local:7024'; I keep getting the following error: Msg 1456, Level 16, State 3, Line 21 The ALTER DATABASE ...
0
votes
2answers
244 views

How and where do I confirm TCP ports are open when performing mirroring? (Principal, Mirror & Witness) [closed]

I have a SQL 2017 Principal, Mirror and Witness that I'm trying to set up for high-availability. I've created certificates specifying port 7024 because the customer is running in a Workgroup and not a ...
3
votes
1answer
282 views

SQL Snapshot Redirect

Company is implementing Database Mirroring Asynchronous with Snapshot. This provides some Disaster Recovery with Reporting area. Server A Principal contains database which mirrors to Server B, ...
1
vote
1answer
365 views

SQL Mirroring Locking/Blocking Contention

We want to setup Mirroring High Performance Asynchronous. Server A Principal contains database which mirrors to ServerB. Mirroring does not allow read-queries unless snapshot is created. 1) If we ...
0
votes
1answer
68 views

SQL Database Mirroring Number Restriction

We are thinking of incorporating Database Mirroring. Company does not have time/budget for AlwaysOn Availability Groups. We currently conduct 24hr backup/restore from one server to another secondary ...
1
vote
1answer
124 views

Restore script while setting up database mirroring on secondary server

I am trying to set up database mirroring for 10-15 databases . All these are around 1-2 TB in size. They have multiple groups and hence are scattered on multiple mount points on their primary server. ...

1
2 3 4 5
7