SQL Server Automatic Page Repair in Database Mirroring
Dear Friends, SQL Server Automatic page repair is one of the cool features of database mirroring which helps us to replace the corrupt page by requesting a readable copy from the …
Read MoreTag: Database Mirroring
SQL Server SNAPSHOT job is running longer than expected
Dear Friends, Today I’m going discuss about an issue that I’ve experienced with SQL Server snapshot job in one of our environments . To give you an overview before I start on …
Read MoreSQL Server – Its -MS + SQLServer
I love giving interviews, one of the question asked in one of my interview question was “on which particular edition automatic page repair is possible (in context of database mirroring)”. That …
Read MoreSQL Server – Automate Index Maintenance in Mirroring environment
I had a scenario where in I had to automate index maintenance in a mirroring environment. Database mirroring requires a database to be in full recovery mode and thus index rebuild …
Read MoreSQL Server 2012 – Introducing Highly Availability using Availability Groups
Case of multi-subnet Windows Failover Cluster What is Highly Available? A high-availability solution masks the effects of a hardware or software failure, outage, planned/unplanned maintenance and maintains the availability of applications …
Read More