Cloud & SQLSailor

Cloud, Databases & Beyond!

Category: Mirroring

July 6, 2012

Automatic Page Repair – Smart fellow who does its work behind the scenes!

Automatic Page Repair is one feature which is not really famous, however pretty much known to most of us. I wanted to write about Automatic Page Repair since a very…
May 16, 2012

Mirroring connection timeout – Looking back at the best practices !

How many times have you followed the best practices check list whenever you are deploying a mission critical solution like Database Mirroring,Log shipping or even Failover cluster instances ? If…
February 2, 2012

Dropping a mirrored database – It just wont ‘allow’ at all!

I have been doing some research with DBM(Database Mirroring) repair features and today I came across this little tricky situation and decided to write about it.Scenario is something like below…
August 5, 2011

Automatic Page Repair,works behind the scene and a wonderful friend of DBA

In a SQL Server 2008 mirroring environment when the primary server detected a corrupt page on disk,it asks the mirror to provide the copy of the page and then correct the…
May 12, 2011

Database Mirroring – some misunderstood concepts

Database mirroring is a wonderful concept and I have observed that there are some misunderstood concepts too within Mirroring.Below are couple of them : Witness server – There is a…