Questions tagged [database-mirroring]

The tag has no usage guidance.

15 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
1answer
1k views

SQL Mirror failing on setup

I've got two SQL servers, I need to mirror a database from one to the other. Should be straight forward, two servers no witness. Both servers are running the same edition of MS SQL Std 2014 The SQL ...
2
votes
1answer
108 views

What options for Windows Server 2008/SQL Server 2008 replication/mirroring across data centres?

Our Microsoft web-application processes around 2000 orders per day. I need to support failover to a secondary data centre. What are the options and experience of implementing a replication/mirroring ...
2
votes
1answer
842 views

SQL Server Database In Single User Mode after Failover

Here is a weird situation we experienced with a SQL Server 2008 Database Mirroring Failover. We have a pair of mirrored databases running in high-availability mode and both the principal and mirror ...
1
vote
1answer
251 views

How to make SQL mirroring endpoint on clustered SQL 2012 instance listen to all IPs?

I have a clustered SQL 2012 standard instance and I want to set up database mirroring. I also need to route the mirroring traffic through a separate NIC. We added the secondary IP to the SQL server ...
1
vote
0answers
106 views

SQL mirror server doesn't connect after reboot with Windows Firewall enabled

I am trying to get database mirroring working properly in high safety mode with automatic failover. I have named instances of SQL Server 2014 installed on Windows Server 2012 R2 for my principal and ...
1
vote
2answers
355 views

SQL mirroring Error- SQL 2008

I am trying to configure SQL Server mirroring and I am getting the following error: The server network address "TCP://santosh-PC:5023" can not be reached or does not exist. Check the network address ...
0
votes
1answer
41 views

Best practices for database with direct user input

I’m currently working on a dynamic project, in which the users feed the database with new objects/data. Other users can later access the data other users provided. Because the data’s coming directly ...
0
votes
0answers
58 views

SQL Server Mirroring and Azure Regions Connection Error

I can't seem to get my SQL Server mirroring to work. I keep getting a server can't be reached when I enable the mirroring part. My virtual machines are in different regions. I can connect to all ...
0
votes
0answers
231 views

SYNC MYSQL database instantly from one Digital ocean server to another

I have a site (data entry site ) on a Digital Ocean server and its database ( MYSQL ) is being updated with new records every second. I am hosting the public site on another Digital ocean server ...
0
votes
1answer
287 views

SQL Server Mirror issue on Mirror side

Team, I am having an issue on one of my Mirroring environment. It is SQL2008R2. DB mirror was somehow broken between principle and Mirror side. Someone(Not sure who is he/she due to offshore support) ...
0
votes
0answers
95 views

SQL Server Witness Server Alternative Approach

I have the setup below: 3 Database Servers 1 DR Database Server 1 Domain Controller 1 DR Domain Controller Currently I have the DR domain controller acting as the mirroring witness for the 3 ...
0
votes
1answer
405 views

SQL 2008 R2 Mirroring Issue

Windows 2008 R2 with SQL 2008 R2 - Using Mirroring of a Database across the WAN in a HA setup with one witness. One issue I am having is during a failure (ever so often) the system fails over or ...
0
votes
1answer
68 views

Two principals in a SQL Server 2005 Mirroring setup

We've recently changed our mirror setup to include a witness so we support automatic failovers, yesterday in our datacenter they had some planned maintenance to some of the network supplies (i believe ...
0
votes
2answers
702 views

F5 LTM 10.2 and MSSQL 08R2

We have a mirrored SQL server setup with a pair of LTM's holding the mirror VIP. We're trying to setup a health monitor that runs a query against both servers in the mirror and directs traffic to the ...
0
votes
1answer
399 views

Best solution for High Availability and SSRS on SQL Server 2008 R2?

I have 2 Physical Servers with SQL Server 2008 R2. – SQL Server 1(Active) & SQL Server 2 (Passive) Web Application is developed using .Net 4.0 Framework. I want to know the best solution to have ...