Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-mirroring]

103 questions
2
votes
5 answers

SQL Server 2005 dropping objects from DB on recovery?

SQL Server 2005 dropped a user from one of our mirrored databases after we recovered from a simple Windows-update induced restart of the machine. I checked and the login is not in the mirror server (it is in the primary). If the system experienced…
Matt Rogish
  • 1,512
  • 6
  • 25
  • 41
2
votes
2 answers

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 to DBB. But then as far as I understand it, any…
Paul
  • 221
  • 5
  • 15
2
votes
1 answer

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 where each of the machines in the setup have plain…
Kenny
  • 520
  • 1
  • 8
  • 24
2
votes
2 answers

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 disaster recovery site. Our current and previous…
Adrian Hope-Bailie
  • 255
  • 4
  • 8
2
votes
3 answers

Limit on number of databases to mirror (MS SQL 2k8)?

I am implementing an SQL failover strategy for ms-sql 2k8, and am thinking of going with database mirroring. I've read that it's not intended for a large number of databases - however the article did not define 'large number'. I'd be looking to…
MCW
2
votes
5 answers

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 principal and secondary server. But when I run the…
Adrian Grigore
  • 1,074
  • 3
  • 21
  • 33
2
votes
1 answer

Database Mirroring Questions

I recently set up SQL 2005 database mirroring (synchronous with witness) on a couple of environments and enjoyed the experience but have a few questions: Does the transaction log chain get broken when a fail-over occurs? Do I need to schedule a…
SuperCoolMoss
  • 1,252
  • 11
  • 20
2
votes
1 answer

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 solution? I've heard it referred to as…
Mark Chidlow
  • 123
  • 3
2
votes
1 answer

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 for other SQL purposes? In particular I am…
DOS
  • 55
  • 4
2
votes
2 answers

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 mirror servers or grid or other than single…
silvercover
  • 19
  • 2
2
votes
3 answers

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 Traffic to a different server (low cost server).…
sqlbuzz
  • 23
  • 4
2
votes
2 answers

Combining failover clustering and database mirroring

When you combine failover clustering and database mirroring in SQL Server, you need to change the mirroring partner timeout value so that the local cluster gets a chance to fail over before database mirroring fails over. I'm curious as to what…
Paul Randal
  • 7,184
  • 1
  • 35
  • 45
2
votes
1 answer

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 high safety mode so two machines will be perfectly…
user596162
2
votes
1 answer

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://202.42.3.54:1433' (IP changed from real for…
Jorge Guzman
  • 337
  • 2
  • 4
  • 14
2
votes
2 answers

MSSQL database mirroring

Reading over (and then testing out on a test database) the setup for mirroring it appears that one is supposed to leave the mirror database in restoration mode for normal operations. is this correct? at whatever point it becomes necessary to…
Devnull
  • 951
  • 1
  • 7
  • 23
1
2
3 4 5 6 7