Can refer to disks in a RAID-1 configuration, or low-latency database replication strategies.
2
votes
0answers
31 views
Failover only working for Classic ASP, not ASP.net
Setup:
All machines run Windows Server 2008 Enterprise
SQL Server 2012 Standard (Primary)
SQL Server 2012 Standard (Mirror)
SQL Server 2012 Express (Witness)
Root issue: Our ASP.NET application is ...
2
votes
0answers
1k views
Reconnect mirroring server SQL2008 R2
The failover server has status (Mirror, Disconnected, In recovery) and principal server has status (Principal, Disconnected).
What is the process to reconnect these servers?
1
vote
0answers
272 views
SQL Server Database Mirroring : strange client application behavior upon failover
I am putting a HA SQL server environment up based on three SQL Server 2008R2 machines and database mirroring.
I'll name them :
principal.company.intra
mirror.company.intra
witness.company.intra
...
1
vote
0answers
77 views
Sql Server 2008 mirroring status different for different logins
We recently had some issues with the failover on a mirrored database: the login kept failing when the primary was down.
On connecting to the database in question with the the login that was failing ...
1
vote
0answers
66 views
Permon counters on SQL 2005 mirroring (user defined counter log file is empty)
I've been attempting to gather performance counters for mirroring using perfmon, over a period of time and saving this to a log file. I am able to do this without problem for general SQL Server ...
0
votes
0answers
26 views
How to get replication from a SQL Server mirroring setup 2008 R2
I have a mirroring setup in the UK (principal, mirror,witness) which hosts a number of databases. failover is automatic for individual databases and local client connections are managed using dynamic ...
