Tag Archives: High Availability

High Availability

Troubleshooting Database Mirroring Error 1418 Updated

June 28, 2012 1:28 pm / Leave a Comment /

Troubleshooting Database Mirroring Error 1418 Updated Last night I was helping someone with a database mirroring setup problem via email. It has been a long time since I came across a new cause for the infamous 1418 error for database mirroring. This time the error was accompanied by an error in the SQL Log on … Read More →

Posted in: SQL Server / Tagged: , , ,

Auditing Users in a Failover Partner Database

September 19, 2011 8:16 pm / Leave a Comment /

Auditing Users in a Failover Partner Database I read a question on a discussion list today asking if it is possible to audit SELECT queries on a log shipping secondary in stand-by mode. His attempts to set it up had obviously failed because the database is read-only and you cannot create a database audit in … Read More →

Posted in: SQL Server / Tagged: , , , , , ,

3 Log Shipping Techniques

June 24, 2011 5:46 am / 6 Comments /

3 Log Shipping Techniques My new article for SQL Server Magazine titled 3 Log Shipping Techniques has been posted online and will appear in an upcoming print issue. This article is a look at some very interesting techniques that use log shipping in interesting ways. Mastering these tehcniques can save you a great deal of … Read More →

Posted in: SQL Server / Tagged: , , , ,

SQLU HA/DR Week – Database Mirroring Performance Counters

April 20, 2011 9:11 am / 3 Comments /

SQLU HA/DR Week – Database Mirroring Performance Counters Database mirroring debuted in SQL Server 2005 and had eleven performance counters for monitoring mirroring. There were ten new performance counters released with SQL Server 2008. We now have twenty-one performance counters to use for monitoring database mirroring. A list with a brief description of each can … Read More →

Posted in: SQL Server / Tagged: , , , , , , ,

Does a Mirroring Failover Clear the Procedure Cache?

February 2, 2011 2:33 pm / 6 Comments /

Does a Mirroring Failover Clear the Procedure Cache? I saw a question on the MSDN forums asking what happens to the procedure cache (also known as the plan cache) on the principal and mirror when a failover occurs. My reply was starting to get long, so I decided to move it out to a blog … Read More →

Posted in: SQL Server / Tagged: , , ,

Multi-subnet Failover Clusters

January 1, 2011 4:46 pm / 3 Comments /

Multi-subnet Failover Clusters I want to take a closer look at one of the new features in SQL Server Denali. While everyone has been drooling over HADRON, another HA feature has gone mostly unnoticed. I haven’t heard anyone talking about it yet, so this should be an introduction to this new feature, Multi-subnet Failover Clusters. … Read More →

Posted in: SQL Server / Tagged: , , ,

Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?

April 7, 2010 11:40 pm / Leave a Comment /

Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances … Read More →

Posted in: SQL Server / Tagged: ,