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
1answer
26 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
72 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
57 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
20 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
19 views

Linked Server to mirrored database trying to connect to secondary

I have a Linked Server which is set up on Server A using a Microsoft OLE DB Provider for SQL Server provider to another server (Server B) I create a local server to remote server login mapping and ...
0
votes
0answers
29 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
54 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
100 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
29 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
19 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
113 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
29 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
106 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
81 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
98 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
67 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
154 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
52 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
351 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
20 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
37 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
25 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
191 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
50 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
368 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
86 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
287 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
322 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
449 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
52 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
675 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
134 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
228 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
260 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
64 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
109 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. ...
0
votes
1answer
759 views

Replication/Mirroring/etc from Azure SQL Database to On-premise SQL Server possible?

I have a table on Azure SQL Database that I would like to have replicated/mirrored to our on-premise SQL Server So the on-prem SQL Server would have a copy of table from Azure that is always up-to-...
0
votes
4answers
7k views

How to solve Error 927 'can not open database' while configuring DB mirroring

Steps I followed: Create DB on primary. Took full backup and log backup. Restored full and log on secondary in NORECOVERY mode (now tb shows restoring satus on secondary I guess this is because ...
0
votes
1answer
601 views

TCP address of SQL server not working in Mirroring

I am trying to mirror a database from my local SQL server instance to another SQL server instance found on the network using SQL Server management studio. I am having troubles providing the TCP:// ...
1
vote
1answer
4k views

Database mirroring stuck in suspended mode

We have an issue with database mirroring on one of the databases on our sql instance where mirroring is suspended for almost 15 hours now. DB is 200 GB on SQL server 2008R2 Sp3+cu with latest patched ...
0
votes
1answer
34 views

After manually fail over resume button is disabled and query doesn't resumes

As there is no witess available, so when resumes the mirrored database by ALTER DATABASE <database_name> SET PARTNER RESUME; does not resumes the mirroring. Resume button is also disabled. I ...
0
votes
0answers
32 views

migrating instance from 2008r to 2016 Enterprise [duplicate]

i have a client that wants to migrate his data to sql server 2016 . currently they have 2008r and the databases are huge(total of 4 tb) on the instance. what is the best way to performe this with the ...
-2
votes
1answer
43 views

What is Mirroring in SQL Server ? When and how it is used? [closed]

Hi i am new to SQL Server and wanted to understand what is mirroring, different types if any and when or what scenario we used mirroring in SQL Server.
0
votes
1answer
25 views

Sql 2016 STD SP1 Always On with DB Mirroring

I have 2 standard editions of sql 2016 sp1. Since only 1 dB is allowed for always on I have to setup other 4 db’s in db mirroring. My always on endpoint is already using port 5022. Is there a place ...
2
votes
0answers
13 views

Is it possible to join servers that are already in a database mirroring session into an Active Directory domain?

We have created a SQL Server database mirroring session on two workgroup servers(not in any domain). Now we are asked to join those two servers into a domain. Is this possible without rebuild the ...
0
votes
1answer
950 views

Configure database mirroring for multiple databases via TSQL or Powershell when mirror is already restoring [closed]

We are trying to automate the mirroring set up for multiple databases whose mirror is already in RESTORING state as the set up was part of log shipping So when we switch from log shipping to mirror I ...
2
votes
1answer
213 views

How to ensure the quick switch from Log shipping to Mirror in SQL Server 2012

Need some Guidance/steps or any reference to link on how safety and quickly can I switch from Log-shipping to Mirroring as we have very small downtime to complete the activity [5-10 mins]. Also how ...
1
vote
1answer
163 views

Why does SQL Server resume mirroring after server is restarted?

I paused database mirroring before I rebooted the Windows server, and I found that the database had resumed mirroring automatically after the reboot. This is not what I want--I want to resume it ...
2
votes
0answers
54 views

Queries running on snapshot database that causes high redo queue

I am trying to troubleshoot mirroring issue where we are getting threshold exceeded for unrestored log too high on mirror server. On the mirror server we have database snapshot created for the ...
2
votes
1answer
87 views

Implementing HA for SQL Server for a .NET Application that uses MS DTC

My production environment uses MS DTC and SQL Server 2014. I must have an HA solution such as Mirroring or AG in place. (Not FCI). I am trying to explain to my team that MS DTC is not supported by ...