1
vote
4answers
179 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 ...
0
votes
1answer
228 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 ...
1
vote
4answers
3k 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
vote
2answers
137 views

Database Snapshots of Mirrored databases affect performance of Principal database?

I have 2 servers set in Mirroring High-safety. One is Principal and another in Mirror. Currently I have 2 snapshots of a Production database (100 GB size) created on Principal server (for no_lock ...
0
votes
2answers
404 views

Tools to manage sql 2008 database mirroring?

We are going to be moving about 20 databases that live on a single instance of sql 2000 to a sql 2008 r2 environment with database mirroring. What I'm looking for is a tool or scripts that will help ...
0
votes
2answers
2k views

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 ...
5
votes
4answers
612 views

Geographical DB synchronus mirroring

An architect in our company has designed a solution based on 64 bit SQL2005 Standard edition synchronous mirroring between a physical (4 quad core, 32GB RAM) server and a virtual DR server (4 virtual ...