Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-mirroring]

103 questions
0
votes
2 answers

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 a different priority when it comes to storing…
therufa
  • 257
  • 1
  • 5
  • 17
0
votes
1 answer

SQL 2008 Datawarehouse Collection Agent Fails with Mirrored Databases on instance

I have a data collection job that fails when a Database on the instance is in Recovery Mode. The database in recovery is the MIRROR partner in the database mirror. The Job that fails is as follows. collection_set_1_noncached_collect_and_upload The…
Dale Wright
  • 91
  • 1
  • 3
0
votes
1 answer

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 tries, but leaves both databases in a Restoring State.…
CWL
  • 107
  • 2
  • 12
0
votes
1 answer

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 Recovery mode on the SQL instance that was…
Kalle
  • 121
  • 1
  • 7
0
votes
2 answers

How can I improve SQL server mirroring performance

(reposted from stackoverflow) I've setup SQL server mirroring, using 2 SQL server 2005 standard editions. When the application is being stressed, response times increase 10-fold. I've pinpointed this to the mirror, because pausing the mirror shows…
Edoode
  • 183
  • 2
  • 7
0
votes
1 answer

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 the main aim of providing redundancy where either…
gb2d
  • 249
  • 4
  • 14
0
votes
1 answer

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://PRINCIPAL:1234 has timed out" error for databaseA.…
Juan Tarquino
  • 113
  • 3
0
votes
1 answer

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 hard to put the feedback in context for our usage…
Chris
  • 164
  • 2
  • 9
0
votes
1 answer

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 they changed some Routers and things). Sadly,…
F.B. ten Kate
  • 123
  • 5
0
votes
1 answer

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 the fact that the pages launch AJAX queries which…
Cameron
  • 3
  • 1
0
votes
1 answer

SQL Server 2008: Mirroring: Threshold Alerts at Database-Level

Testing I have completed to date seems to indicate that the following Threshold Alerts need to be defined for the Database Name rather than a single named database: Unsent Log Threshold (Error Message 32042) Oldest Unsent…
EngineeringSQL
  • 275
  • 1
  • 2
  • 8
0
votes
1 answer

Can't Mirror Database on Sql-Server 2008

I'm running two MS-SQL instances to create a mirrored-database environment, I have an instance in a Virtual Machine and another instance, alongside the witness, in the physical machine. I know this isn't the best configuration but this is for…
PedroC88
  • 131
  • 3
0
votes
2 answers

How to keep Ms-SQL database always UP: mirroring or replicationg?

I have several Tb databases in the Windows Server 2008. I would like to keep alive the service when the server is failing or the raids are needs to be rebuild. Which model to choose Replication or Mirroring? And how to setup that the alive server…
Arman
  • 555
  • 2
  • 8
  • 18
0
votes
2 answers

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 principal. Right now we have a query running…
wenzthis
  • 1
  • 1
0
votes
1 answer

Unusual CPU usage on SQL 2005 Mirror

We are running a mirror on SQL Server 2005 SP2 Enterprise edition for a few databases. These are running on VMWare with Server 2008 R2. On the mirror server, I see the CPU go up to 50% for about a minute every 10 minutes (on the tens). Here's…
Paul Kroon
  • 2,220
  • 16
  • 20
1 2 3 4 5
6
7