5
votes
1answer
1k views

How do I shrink the physical Transaction Log file when it's the principal in a mirror?

We setup database mirroring over the weekend, and forgot to re-enable the job that backs up the transaction logs. When I came in this morning, the transaction log had ballooned to 58GB, and was taking ...
1
vote
1answer
137 views

Can I run a Report Server and a Mirror server from a working Log Shipping secondary instance? [closed]

Our setup: City A - Primary server for logshipping City B - Secondary server for logshipping Now there is a lot of data being updated from A - B. And the server in City B is underutilized, and it ...
0
votes
1answer
133 views

SQL Server Mirror failover on failing storage

Recently we had an issue with a sql server 2008 r2 HA mirror. I have tried to reproduce this in a lab environment and i came to the conclusion that i am missing something OR something is not possible. ...
5
votes
1answer
2k views

Mirroring - Server network address cannot be reached

I have SQL Server 2008 R2 Installed. It contains three instances. Default (MSSQLServer) FirstInstance SecondInstance All these are Log On as Network Service.. Default Instance is Principa ...
9
votes
3answers
6k views

What can cause a mirroring session to timeout then failover? SQL Server 2005

We have two production SQL Servers running SQL Server 2005 SP4 with cumulative update 3. Both servers run on physical machines that are identical. DELL PowerEdge R815 with 4 x 12 core CPUs and 512GB ...
2
votes
2answers
124 views

Impact of using mirroring to migrate between SQL Server 2005 and SQL Server 2008 R2

I've got a DB which sits on a machine (SQL Server 2005) due for replacement very soon. I'm planning on having the database mirrored to the replacement machine (SQL Server 2008 R2) so that when the ...
0
votes
2answers
548 views

Mirroring after restoring the database on a new machine

We've had alot of problems with one of our database servers and two days ago the call was made to change a disk and reinstall the OS. Now this server functioned as part of a mirroring setup. Basically ...
2
votes
2answers
383 views

Database Mirroring Failure Reasons

I was wondering if there is any information on what scenarios might cause a DB Mirror to have to be recreated? I am attempting to research how sturdy the technology is and under what scenarios do we ...
3
votes
2answers
152 views

Database Mirroring of SQL server

I have two databases that are mirrored to another server using database mirroring. The mirror server has to be down for some reason for few days. Now, the production server is having principal ...