0
votes
1answer
47 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
votes
2answers
30 views

SQL Mirroring on Live System? [closed]

My project has a SQL 2008 database with production data on it in use at all times. We need to move our entire production network from one hosting environment to another. We've already stood up the ...
1
vote
4answers
4k 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
1answer
199 views

SQL connection with mirroring still working after a failover

I have a windows service application that is instaled on two servers, SQL01 and SQL02. On both server there is a SQL server (X1 and X2), which have the same content. A mirroring partnership was set up ...
1
vote
2answers
147 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
420 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 ...
3
votes
3answers
13k views

SQL 2008 Mirroring, how to failover from the mirror database?

I have configured a database mirroring setup in SQL 2008 using the High-safety, Synchronous mode, without automatic failover. I don't have a Witness instance. Regarding high availability, I ...