Questions tagged [database-mirroring]
The database-mirroring tag has no usage guidance.
104
questions
0
votes
1
answer
43
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 (~...
- 111
1
vote
0
answers
253
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.
...
- 270
0
votes
1
answer
62
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
2
answers
156
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 ...
1
vote
1
answer
321
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 ...
- 153
1
vote
0
answers
140
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 ...
- 11
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 ...
- 1,260
0
votes
1
answer
4k
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 ...
- 1,287
0
votes
0
answers
59
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 ...
- 283
0
votes
0
answers
243
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 ...
- 161
0
votes
1
answer
306
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) ...
- 1
0
votes
1
answer
156
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 ...
- 569
0
votes
1
answer
438
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 ...
- 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 ...
- 419
0
votes
1
answer
402
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, ...
- 147
-1
votes
1
answer
682
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 ...
- 169
0
votes
0
answers
111
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 ...
6
votes
1
answer
128
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 ...
- 513
0
votes
1
answer
224
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 ...
- 113
0
votes
1
answer
103
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 ...
- 113
1
vote
1
answer
102
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 ...
- 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 ...
- 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 ...
- 89
0
votes
1
answer
435
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 ...
- 113
0
votes
2
answers
148
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 ...
- 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 ...
- 257
0
votes
1
answer
406
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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
1
vote
4
answers
455
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 ...
- 111
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
...
- 5,823
0
votes
1
answer
297
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 ...
- 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://...
- 113
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 ...
- 1,072
0
votes
1
answer
95
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 ...
- 164
0
votes
1
answer
71
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 ...
- 123
1
vote
2
answers
357
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 ...
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 ...
- 123
2
votes
1
answer
145
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 ...
- 55
0
votes
1
answer
261
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 ...
- 3
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 ...
- 229
2
votes
2
answers
219
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 ...
- 19
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 ...
- 23
1
vote
3
answers
5k
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 ...
- 491
2
votes
1
answer
290
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 ...
user596162
2
votes
1
answer
740
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:...
- 337
3
votes
1
answer
4k
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 ...
- 7,920
1
vote
3
answers
3k
views
MSSQL Mirroring Failover: Login failed for user
When MSSQL DB Mirroring fails over, our script won't login, fails on:
Cannot open database requested by the login. The login failed. Login failed for user ...
The way I can fix this is by running:
...
- 400