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…
![](../../users/profiles/1478.webp)
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…
![](../../users/profiles/19925.webp)
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…
![](../../users/profiles/36720.webp)
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…
![](../../users/profiles/126325.webp)
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…
![](../../users/profiles/3347.webp)
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…
![](../../users/profiles/2943.webp)
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…
![](../../users/profiles/87852.webp)
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…
![](../../users/profiles/83109.webp)
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…
![](../../users/profiles/84540.webp)
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).…
![](../../users/profiles/61927.webp)
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…
![](../../users/profiles/1992.webp)
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…
![](../../users/profiles/79019.webp)
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…
![](../../users/profiles/11087.webp)
Devnull
- 951
- 1
- 7
- 23