Log in | Register

High Availability & Disaster Recovery Archives - SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education High Availability & Disaster Recovery Archives - SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education

High Availability & Disaster Recovery

SQLServerGeeks Annual Summit 2016 IS HAPPENING IN BANGALORE. HAVE YOU REGISTERED?

SQL Server Replication Log Reader Why and How latency occurs

We, as a DBA, have many times been in a situation where your log reader goes into latency and no matter how much you troubleshoot it come back when it should and there is nothing you can do about it. Yes, as per the design on SQL Server Replication log reader there very little […]

Alwayson availability group setup, Checking for compatibility of the database file location on the secondary replica resulted in an error

Hi Friends,

Few days back I received a call from one of my friend mentioning that he ran into an issue while alwayson availability group setup. He did add two replicas successfully but at the time of validation, configuration wizard failed with following error (I’ve pasted error screenshot as well);

Checking for compatibility of the database […]

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 partner database. Today, I’ll simulate a page corruption and show how this feature is helpful to recover damaged page.

For this demonstration, I’ve used database […]

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 the actual problem; we have mirroring setup and on mirror server snapshotjob scheduled to run 4 times a day as per client requirement and is […]

Joining database on secondary replica resulted in an error

Hi Friends,

Always On Availability Groups provides an enterprise-level alternative to database mirroring and it gives organizations the ability to manually or automatically fail over a group of database(s) as a single unit with support for up to four secondary(s). Many organizations at present are opting for this excellent feature as their HA solution that […]

SQL 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 results in huge logs being generated and this directly affects the mirroring throughput. The general guidelines to solve this problem is

– to switch […]

Newsletter_Footer