Questions tagged [database-mirroring]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
2 answers
84 views

How should databases be configured for different environments to not lose data

How to configure databases for development, staging and production environments so that there will be no any data loss. Many Applications such as Wordpress, Django, etc... use some database to store ...
zakadmin's user avatar
0 votes
1 answer
102 views

Copied or restored contents of one Azure Storage Account to another

Has anyone copied or restored contents of one Azure Storage Account to another? We have created a PowerShell script using AzCopy to do this. But, the storage account that has over 5,000 containers (~...
Joy1979's user avatar
  • 111
1 vote
0 answers
677 views

AWS: Unable to drop MSSQL RDS database

We have an RDS MSSQL instance, configured as Multi-AZ. I created a test DB, "Moose" on RDS. After 5-10 minutes, it shows "(Principal, Synchronized)" in SSMS <= So far, so good. ...
paulsm4's user avatar
  • 270
0 votes
1 answer
66 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 ...
thisismoooo's user avatar
0 votes
2 answers
168 views

Apache / MariaDB Questions

this is my first post here, and I have searched for a good answer to this question with no luck so far. I am in the process of upgrading our web server (LAMP stack on CentOS 6) to new hardware and ...
TheMalman's user avatar
1 vote
1 answer
431 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 ...
StepCZ's user avatar
  • 153
1 vote
0 answers
178 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 ...
Joel Kolb's user avatar
2 votes
1 answer
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 ...
Patrick's user avatar
  • 1,290
0 votes
1 answer
5k views

Database server vs NAS for data files

Regarding costs and maintenance speed/simplicity in case of hardwar failures, does it make any sense to keep SQL data files on a NAS server, separate from the SQL Server instance? Our app stores large ...
vgru's user avatar
  • 1,297
0 votes
0 answers
60 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 ...
exposure's user avatar
  • 283
0 votes
0 answers
252 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 ...
brainHax's user avatar
  • 161
0 votes
1 answer
346 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) ...
user335413's user avatar
0 votes
1 answer
162 views

What carries out SQL Server Mirroring?

I'd like to know what service(s)/process(s) carries out Mirroring in SQL Server. For example, we have various Agents carrying out the different steps for SQL Database Replication. Similarly, what is ...
Santa's user avatar
  • 579
0 votes
1 answer
441 views

Migrating from normal RDS to Encrypted RDS

I saw this and this which in theory are the same, but no extra details were given, so they answers are general and unsolved. My issues is similar, with a sad twist: I have a Master RDS instance ...
dulac's user avatar
  • 133
3 votes
1 answer
1k views

Error configuring witness server for failover in SQL Server

I'm lost here, I am configuring a SQL Server for failover and have three servers. Principal server > SQL 2008 R2 Witness server > SQL 2014 Mirror server > SQL 2008 R2 All three servers can ping the ...
Tom's user avatar
  • 419
0 votes
1 answer
410 views

SQL Server 2012 AlwaysOn Availability Groups Server Logins Fails When Switching Between Nodes

I am setting up a 3 node cluster as part of an availability group. Initially I tested failover between nodes using SQL Management Studio and everything failed over successfully when I stopped a node, ...
leeman24's user avatar
  • 147
-1 votes
1 answer
712 views

What are the best practices to mirror a web app? [closed]

I'm using a dedicated server which virtualize Linux machines, the data-center is located in Europe. All the virtual machines are Linux servers, one is the Apache front-end while another is Mysql ...
Michele's user avatar
  • 169
0 votes
0 answers
116 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 ...
totalfreakingnoob's user avatar
6 votes
1 answer
130 views

Copy SQL Server Databases

I am looking to "move" databases to different servers with minimal disruption to data and service. These databases vary in size from 5GB to 140 GB. I've seen and even used some of the various data ...
Black Dynamite's user avatar
0 votes
1 answer
237 views

Migrate existing database to mirrored database on Azure

I have setup 3 Sql VM's on Azure for database mirroring as described in this link with the idea being that we move our current database, which is currently on a single VM outside of Azure. Everything ...
Peuge's user avatar
  • 113
0 votes
1 answer
108 views

Two SQL Failover Clusters in two-node failover servers

I need 2 SQL Failover clusters: Core Database Cluster: this contains all of my core application databases Analytic Database Cluster: this contains my web analytic database Now, I only have 2 ...
ronanray's user avatar
  • 113
1 vote
1 answer
105 views

SQL server many to one mirroring

I have two SQL servers, server A and server B running SQL Server 2008 R2 Standard. Can I setup a third server that will be a mirror for both server A and server B? I can't seem to find any ...
Alex's user avatar
  • 38
2 votes
2 answers
1k views

Where does data go during a SQL mirroring failover?

I'm just about to setup a SQL mirror but there's one thing I haven't managed to work out yet. If I'm mirroring DBA (principal) to DBB (mirror), and DBA goes offline, it will automatically switch over ...
Paul's user avatar
  • 221
1 vote
1 answer
7k views

MS SQL Start Mirroring Error

Helo, I'm trying to mirror a db using a Principal, Mirror, and a Witness server. Each computer that has it's own local ip address (v4) and I made them static so they would not change. Then I did ...
compcobalt's user avatar
0 votes
1 answer
443 views

SQL 2008 R2 Clustering AND DB Mirroring (Async)

I've got a MS SQL 2008 R2 Fail-Over Clustered Instance running between two Windows 2008 R2 servers using the inbuilt Windows Clustering features, that is working with a DTC and Quorum with a disk ...
Ben Bowman's user avatar
0 votes
2 answers
156 views

Azure Table Storage mirroring

I am proposing an Azure environment with the following: VM SQL Server for core relational data Table Storage for bulk data I want to mirror the SQL Server database to another server so that Reports ...
Dave New's user avatar
  • 155
0 votes
2 answers
3k views

Synchronisation between MySQL databases on different hosts

I want to solve a data replication/data sync problem between two MySQL server instances. Both of them have the same database structure (databases, tables, columns, everyting ...) but each of them has ...
therufa's user avatar
  • 257
0 votes
1 answer
407 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 ...
CWL's user avatar
  • 107
3 votes
3 answers
6k views

Simplest way to shrink transaction log files on a mirrored production database

What's the simplest way to shrink transaction log file on a mirrored production database? I have to, as my disk space is running out. I will make a full database backup before I do this, so I don't ...
MGOwen's user avatar
  • 307
0 votes
1 answer
2k views

Restarting MSSQLSERVER service on the principal or on the mirror the database is set in "In Recovery" mode

I'm running MSSQL Server 11.0.2100 (SQL Server 2012) and every time I restart the MSSQLSERVER service on the principal or on the mirror, the database mirror breaks and the database is set into In ...
Kalle's user avatar
  • 121
2 votes
1 answer
1k views

SQL Server 2012 Mirroring / AlwaysOn - need for SAN?

There appears to be a great deal of conflicting information about whether or not SAN is required for a Sql Server 2012 Mirroring setup. I currently have an Active-Passive-Witness SQL 2008R2 setup ...
Kenny's user avatar
  • 520
2 votes
2 answers
6k views

What the best way to achieve RPO of zero and lowest possible RTO (less than 15 minutes) with SQL 2008 R2?

We are running a payments (EFT transaction processing) application which is processing high volumes of transactions 24/7 and are currently investigating a better way of doing DB replication to our ...
Adrian Hope-Bailie's user avatar
1 vote
4 answers
479 views

MS Sql Server Mirroring

We are looking at mirroring a MS SQL database (for a web application) due to the unique way the application was developed, each user has a SQL server Login user account which has permissions to our ...
Matt Seymour's user avatar
4 votes
2 answers
2k views

How to slave real-time data from two MySQL sources merging in to one MySQL destination?

I have two different MySQL instances that I would like to 'slave' to a third instance. (so I can do easy joins on the third instance) eg. mysql1> show databases db1 db2 mysql2> show databases ...
Joel K's user avatar
  • 5,903
0 votes
1 answer
309 views

Server mirroring strategy questions SQL Server replication, MySQL replication, file replication, etc

I'm working as an application developer for a company that I've been with for for some time. The business would like to mirror their existing windows server (server A) to a new server (server B) with ...
gbro3n's user avatar
  • 259
0 votes
1 answer
1k views

What happens when Mirror times out with Principal, but Principal does not timeout with Witness or Mirror?

We have three SQL server 2008 r2 servers (principal, mirror and witness) setup for mirroring (with safety option). I see in the Mirror server logs that there was a "The mirroring connection to TCP://...
Juan Tarquino's user avatar
2 votes
5 answers
10k views

Cannot add witness to my mirroring setup

I'm trying to set up mirroring with a witness using my 3 dedicated servers running SQL Server 2008 R2. I've set up everything as described at this blog post Mirroring seems to work fine between the ...
Adrian Grigore's user avatar
0 votes
1 answer
111 views

MS SQL Hardware Configuration

About to order a replacement mirrored database pair to drive our multi-user web applications and looking for some guidance on some aspects. I have read various feedback on other posts but finding it ...
Chris's user avatar
  • 174
0 votes
1 answer
72 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 ...
F.B. ten Kate's user avatar
1 vote
2 answers
360 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 ...
Santosh.richlad's user avatar
2 votes
1 answer
109 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 ...
Mark Chidlow's user avatar
2 votes
1 answer
147 views

SQL Server Mirroring - Should Witness server be dedicated to mirroring?

Scenario - SQL Server 2008 R2 Mirrored environment - High Safety synchronous with automated failover. Witness Server is a SQL Server 2008 R2 Express Edition. Question: Can the Witness server be used ...
DOS's user avatar
  • 55
0 votes
1 answer
262 views

Distributed Database Services?

I'm working on a database-driven web service with clients in the US and Australia. We're currently hosted in the US, however our Australian clients are experiencing lag. The lag is primarily due to ...
Cameron's user avatar
3 votes
3 answers
26k views

Which ports to open for DB Mirroring

We have two physical servers on the different area protected by firewalls. We need to use DB Mirroring for our purpose. So which ports we need to open between two area for using MS SQL 2008 DB ...
Sasha's user avatar
  • 229
2 votes
2 answers
220 views

More than one MySQL server

I have a growing website which now uses a single and ordinary MySQL server for its tasks. I wonder how and when should I migrate to more powerful servers or in other words when is the best time to use ...
silvercover's user avatar
2 votes
3 answers
214 views

Replication or?

Recently, we have been hammered by Google Bots and all kinds of other bots( 60% of the website traffic that we experience on an average are from Bots. We are trying to segment out the Google Bot ...
sqlbuzz's user avatar
  • 23
1 vote
3 answers
6k views

SQL Server mirroring - how many sql mirrored servers can you have?

I want to setup SQL Server mirror on amazon EC2 but I always have to add additional storage and worried when i do this my data might get erased? 1) how many principal servers and mirror servers can ...
001's user avatar
  • 491
2 votes
1 answer
293 views

Sql Server 2008 high availability in EC2

I'm currently evaluating a strategy that will enable high availability with SQL Server 2008 and redundant servers to limit DB downtime. My thought right now is to setup SQL server 2008 mirroring in ...
user avatar
2 votes
1 answer
757 views

How do you setup mirroring in SQL 2005 with IP addresses for server names? (EC2 / no AD)

I am setting up a mirror in Amazon EC2 and I have all servers with dedicated IPs. When i try to connect my mirror to my principal with the following command alter database DB_NAME set partner = 'TCP:...
Jorge Guzman's user avatar
3 votes
1 answer
5k views

SQL Server mirroring refuses to work. Tearing my hair out

I'm trying to attempt what I thought would be a very simple process - the mirroring of a database between two MSSQL 2008 R2 servers within the same domain. Both servers are configured similarly, and ...
growse's user avatar
  • 8,050