Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [mirroring]

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

0
votes
1answer
16 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 ...
0
votes
0answers
25 views

The right choice to distribute reads and writes on different servers [on hold]

I have to get applications on my SQL Server 2017 Standard make reads faster and writes faster. Sometimes the reads and even the updates got blocked (300 deadlocks from the start of year). I have the ...
2
votes
1answer
49 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

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
49 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
102 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
43 views

SQL Server 2012 R2 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
149 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
16 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
24 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
22 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
90 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 ...
-1
votes
0answers
33 views

How do I determine the cause of a SQL 2017 Mirroring Login Failure?

I have two SQL 2017 servers set up to create a Read-only replica on the secondary. All was working, but suddenly without any user intervention, the mirroring has stopped. I am seeing the following in ...
2
votes
0answers
45 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 ...
0
votes
0answers
42 views

SQL Server Mirroring Setup

I'm setting up synchronous mirroring and I would like to get the process down to as few steps as possible. My system does a full backup of each database once a day and differential backups every four ...
2
votes
1answer
168 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
62 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
0answers
146 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
181 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
268 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
48 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
295 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
96 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
178 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
158 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
63 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
70 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
480 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
3k 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
335 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
2k 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
32 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
38 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
23 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
12 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
606 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
164 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
116 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
46 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
73 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 ...
0
votes
1answer
546 views

Unsent log behaviour in database mirroring

Need your suggestion on how below works. Situation: We had unsent log on Principal stuck for almost 10 hours with unsent data around 200 GB. Action: Paused and resumed the mirroring. This kicked of ...
0
votes
0answers
105 views

SQL Server best option for low-cost high-availability and queryable secondary?

We have a heavily used database server (SQL 2012 Web edition) which is currently a single point of failure (nightly backups and no additional hardware provisioned!) The server has a constant stream ...
2
votes
2answers
42 views

Moving SQL to a hosted server

I'm in the process of moving a large (7GB-9GB) database to a hosted server. the old server uses SQL 2008 R2 and the new one is using SQL 2016. I'm trying to find the best way to reduce the downtime ...
4
votes
2answers
561 views

Replicate single table from SQL Express to SQL Enterprise 2014

We have a small branch app that stores some data in a SQL Express Database. We want to have an almost real time copy of this table in our headquarters, were we have SQL Enterprise 2014. I say almost, ...
0
votes
1answer
1k views

Setting up Mirroring in SQL Express Edition

I know doing something like mirroring in SQL Server express edition is not possible, but can we do real-time db backup and restore and setup some automated task which acts like mirroring and keep them ...
0
votes
1answer
77 views

Automatic failover support on SQL Server having only two servers

We have two servers each one occupied by a dedicated storage. I am looking for the a way to setup these two servers to provide a database on MS SQL Server with automatic fail-over support. Using ...
-1
votes
1answer
166 views

Alter database XXXXX set partner timeout 30 on mirroring database [closed]

'Alter database XXXXX set partner timeout 30' will this kill the users in the database Can this command be run on database whilst it is being actively used.
0
votes
1answer
267 views

How to query Mirroring RTO & RPO from system objects

Forward Clarification: I'm using RPO to describe "Estimated Data Loss", and RTO to describe "Estimated Recovery Time" in this question. I realize they're not exact definitions, but are close enough ...
1
vote
1answer
38 views

Does database mirroring replicate the time stamp for database backups?

We use Quest Spotlight for database server monitoring. Depending on when SQL server decides to fail over automatically, we will get an alert stating that a database has not been backed up in over ...