Category Archives: High Avaliability

vNext has AG

Now vNext SQL Server on Linux supports Availability Group HA/DR functionality supported.   https://blogs.technet.microsoft.com/dataplatforminsider/2017/02/17/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups/    

Posted in Disaster Recovery, High Avaliability, Others, SQLonLinux, vNext | Tagged , , | Leave a comment

Distributed AG

going though Allan Hirt’s 24 SQLPASS  recording, he has explained the new feature of SQL Server Availability group you can get it here. http://www.sqlpass.org/24hours/2016/summitpreview/Sessions.aspx he is expert in Clustering /AG/ and published several blogs and books. Distributed AG is advance and extended … Continue reading

Posted in High Avaliability, Others, sql 2016 | Tagged , , , , | Leave a comment

Re-initialize replication not working

For someone re-initialization is very simple, just go to publisher and right click and select re-initiallize and it will ask for- do you want to generate snapshot now, if you say “yes” it will create a metadata of the articles … Continue reading

Posted in Add/remove, High Avaliability, Replication, Troubleshooting | 1 Comment

Sql Cluster Resource not comming online

when you check on the sql server services and sql agent services it’s getting started on windows cluster but on cluster its going down again. on error log you may get the cluster service Login failed for user ‘cluster service … Continue reading

Posted in Add/remove, Bug, Disaster Recovery, Error Log, High Avaliability | Tagged , , , , | Leave a comment

Cluster failover fails

you may get an error while trying to failover to another node cluster.   to resolve this issue create an alias on the node with the cluster name and it should work. will blog more on this later.  

Posted in High Avaliability, Troubleshooting | Leave a comment

Denali – Day 2: AlwaysON High Availability (aka Project HADRON)

Denali – Day 2: AlwaysON High Availability (aka Project HADRON ) AlwaysON Availability Group: is another very important achievement done by development team project called “HADRON”. As the name implies AlwaysON is a High availability feature on Failure Clustering where it has … Continue reading

Posted in Denali, Disaster Recovery, High Avaliability | Tagged , , | Leave a comment

High Availability 9’s

This is very important to understand what is high availability 9’s, This is a measurement of high availability  where you can tell how much downtime is feasible for your organization for a Year(annually). the calculation is as follows =Total Hours in a … Continue reading

Posted in Disaster Recovery, High Avaliability | Tagged , | Leave a comment

Dynamic Add/Remove file in Mirroring/Logshipping

Yesterday we were having discussion on high availability feature Mirroring and Log shipping with my colleagues (Amol & Alankar) on whether can we dynamically add/drop any new file in our principle or primary database, got conclusion that YES it is … Continue reading

Posted in Add/remove, Disaster Recovery, High Avaliability | Tagged , | Leave a comment

Day 27: Log Shipping Errors

Day 27: Log Shipping Errors Log shipping is another tool for High availability it will generally have primary and secondary server, Full Backup restores at both location and then Tlog backups will copied to secondary server and restore. The step … Continue reading

Posted in High Avaliability, Troubleshooting | Tagged , | 1 Comment

Failure Cluster -General

We have discussed some basic high availability here. Yesterday we were discussing about Windows clustering (here on will say “Clustering”) and realized that I have not blog much about clustering, Here I will be considering 2 node clustering “Active -Passive” … Continue reading

Posted in High Avaliability, Whitepapers | Tagged , | Leave a comment