1
vote
1answer
72 views

SQL Server database Mirroring on different servers

I tried to perform SQL Server database Mirroring(with SQL Server 2008R2). And I got success to perform mirroring with "High Safety" mode. And for that I have used three instances of SQL Server ...
1
vote
0answers
22 views

Database slowdown at random times using mirroing

Our web application suffers DB query timeouts a few times a day at random times. Can you help to work out the cause, e.g. deadlocks, mirroring (disk or network), etc? We have two identical database ...
0
votes
0answers
77 views

Database mirroring partner cannot connect to witness

So, I am not sure when this started but at some point in my database mirroring configuration, one of the partners (currently the mirror) stopped being able to connect to the witness. This is a ...
0
votes
1answer
34 views

Can't set up mirroring for a specific database

We have several databases. All of them are mirrored. Until now, we never had issues with this. One database had some problems, and now when we try to enable mirror again, it just stops. Message in ...
2
votes
0answers
148 views

database mirror problem with Network Service account

I have two SQL Server 2008 R2 instances installed on same Server and the engine log on as Network Service account which is set by installation. there is a database TestDB on both instances. I try to ...
0
votes
1answer
1k views

Best Possible Solution for Reporting Mirroring or Replication?

Hi I have SQL SERVER 2008R2 Data Centre Edition and I use SSRS and a Vendor application for reporting. I have a Reporting Server where we backup and restore everyday from Live Server to have Data ...
3
votes
1answer
217 views

Changing autogrow settings with database mirroring

Recently I changed the Autogrow settings for some of the databases on our SQL Server 2008 R2 server. These are involved in a database mirroring configuration, with the principal on SERVER1 and the ...
0
votes
2answers
122 views

Can I use replication/mirroring to have a “Current” database and a “Full History” copy?

I have a database that is used for current operations. The amount of data is starting to get a bit to much for the applications using it. Most of the data is older and is very rarely needed. I am ...
5
votes
2answers
98 views

Retrieving cached plans fails due to cached objects of database Mirror

I'm trying to retrieve cached execution plans for a specific database object, but this fails because of cached plans which belong to a mirrored database in MIRROR state. The below query, without any ...
1
vote
1answer
331 views

SQL Server 2008 R2 database mirroring - is it possible to have a slave server for multiple master servers?

Scenario is that I have two servers running SQL Server 2008 R2 (64-bit), let's call them DB1 and DB2. I have set up database mirroring for all the databases on these servers so that DB1 is the ...
5
votes
2answers
1k views

Manually moving SQL instance to another node causes immediate database mirror failover

I have a two-node SQL cluster (2008 R2). Some of the databases within that SQL instance are mirrored to another server on a remote site, using the High safety with automatic failover. The mirroring ...
2
votes
1answer
161 views

tempdb thrashing and mirroring permissions (SQL Server) [closed]

We have a client site that uses SQL Server. The site this morning was slow, and we realised that the primary database server was responsible for a lot of disk activity on tempdb (Server 2008, SQL ...