0
votes
1answer
35 views

Sql Server Transaction Log Backup Fails

I have a Sql Server 2008 Standard version. Mirroring is set up on the server in full safety mode. Its been working fine till today. The transaction log back-up fails every-time with an error "Error: ...
1
vote
1answer
110 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
180 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
239 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 ...
1
vote
2answers
143 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
718 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
347 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
417 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
618 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 ...