1
vote
1answer
94 views

Failover server for SQL Server mirror errors after reboot

I have two Windows Server 2008 servers set up, both running SQL Server 2008 R2. One is used as a primary DB, the other as a mirror failover (two website DBs + ASPState for sessions). Everything works ...
1
vote
4answers
177 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 ...
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 ...
0
votes
2answers
229 views

SQL server 2008 R2 with IIS on same machine and mirroring

I want to install SQL server 2008 R2 and IIS on same server with a mirroring configuration with principal/mirror/witness setup. Both principal and mirror servers will have IIS and SQL server. My ...
0
votes
0answers
134 views

SQL Server 2008 R2 Data Mirroring issue

I'm trying to setup Data mirroring between 2 servers. Error: “The server network address “TCP://servername:5022″ can not be reached or does not exist. Check the network address name and that the ...
1
vote
2answers
130 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 ...
1
vote
3answers
634 views

Real time mirroring between two sql server databases

I'm a c# programmer, not a DBA and I've had the (mis)fortune to be handed a database admin task. So please bear this in mind when answering this question. What I've been asked to do is to create a ...
1
vote
2answers
340 views

I need complete tutorial about MSSQL 2008 Database mirroring for load balancing

I need complete tutorial about MSSQL 2008 Database mirroring for load balancing i want to load balance my SQL workload all database insert update and delete queries will be mirrored all select ...
0
votes
2answers
379 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 ...
1
vote
2answers
163 views

SQL Server 2005 mirroring 2-1

I want to setup a single instance of sql-server as a mirror-backup for 2 production-servers, and I need to use certificate authentication because they are not part of an AD-domain. Reading the ...
5
votes
4answers
597 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 ...
4
votes
1answer
4k views

SQL mirroring or log-shipping - which has the least impact on a replicated database?

We're planning a server which is a clustered SQL2005 Enterprise 64bit with a database of which a subset of tables are replicated one way via transactional replication to single subscriber located at ...