The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
2answers
222 views

SQL mirroring Error- SQL 2008

I am trying to configure SQL Server mirroring and I am getting the following error: The server network address "TCP://santosh-PC:5023" can not be reached or does not exist. Check the network address ...
2
votes
1answer
99 views

What options for Windows Server 2008/SQL Server 2008 replication/mirroring across data centres?

Our Microsoft web-application processes around 2000 orders per day. I need to support failover to a secondary data centre. What are the options and experience of implementing a replication/mirroring ...
2
votes
1answer
361 views

SQL Server Database In Single User Mode after Failover

Here is a weird situation we experienced with a SQL Server 2008 Database Mirroring Failover. We have a pair of mirrored databases running in high-availability mode and both the principal and mirror ...
0
votes
1answer
153 views

SQL 2008 R2 Mirroring Issue

Windows 2008 R2 with SQL 2008 R2 - Using Mirroring of a Database across the WAN in a HA setup with one witness. One issue I am having is during a failure (ever so often) the system fails over or ...
0
votes
1answer
53 views

Two principals in a SQL Server 2005 Mirroring setup

We've recently changed our mirror setup to include a witness so we support automatic failovers, yesterday in our datacenter they had some planned maintenance to some of the network supplies (i believe ...
0
votes
1answer
446 views

F5 LTM 10.2 and MSSQL 08R2

We have a mirrored SQL server setup with a pair of LTM's holding the mirror VIP. We're trying to setup a health monitor that runs a query against both servers in the mirror and directs traffic to the ...
0
votes
1answer
342 views

Best solution for High Availability and SSRS on SQL Server 2008 R2?

I have 2 Physical Servers with SQL Server 2008 R2. – SQL Server 1(Active) & SQL Server 2 (Passive) Web Application is developed using .Net 4.0 Framework. I want to know the best solution to have ...
0
votes
0answers
16 views

SQL Server Witness Server Alternative Approach

I have the setup below: 3 Database Servers 1 DR Database Server 1 Domain Controller 1 DR Domain Controller Currently I have the DR domain controller acting as the mirroring witness for the 3 ...