I have a mirrored SQL Server 2012 database. The first server has a hugh tempdb write IO load when the maximum memory limit is set above 8192 mb. These 8192 where the original setting for both the ...
I am running Windows update on my SQL Servers (which are in a Principal-Mirror partnership, in High Safety mode). I am starting with updating the mirror and I was wondering, to increase safety, ...
SQL Server: Principal DB becomes unavailable after problem with mirror DB, even with Set Partner Safety Off?
We've got a very simple mirroring setup here: just a principal DB and mirror DB, no witness, running in high-performance mode with SET PARTNER SAFETY OFF. This problem has happened to us twice now: ...
I have been trying to learn to do this. I've got newly installed Win 2008 R2 machines, in a workgroup, in the same subnet, and of course SQL Server 2012. I allowed login with SQL Server ...
Can I use SQL 2008 R2 as a Witness Server for 2 instances of SQL 2012 Servers being mirrored?