Category Archives: Disaster Recovery

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/     Advertisements

Posted in Disaster Recovery, High Avaliability, Others, SQLonLinux, vNext | Tagged , , | Leave a 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

Denali — Day 6: indirect Checkpoint

Denali – Day 6: indirect Checkpoint I have already blog some information about checkpoint here As I have already blog about Checkpoint and how it works. Generally it works approximately every 1 minute(internal – default) . You could do this … Continue reading

Posted in Denali, Disaster Recovery, Transaction Log | Tagged , , | 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

Suspect Database

Suspect database generally caused by internal IO issue, and the best way to resolve it to ask hardware person to check and correct the issue. And sql server dba has to monitor it. Check the database consistence using DBCC CHECKDB … Continue reading

Posted in Backup and Restore, Disaster Recovery, Experts, Troubleshooting | Tagged , , | Leave a comment

Difference between Mirroring and Log Shipping

It’s been quite some time that I blog, Sorry about that I was busy with my movement from USA to India and changed my job  part of life ,okay  back to India (Pune). Lastly I wrote a blog on High Availability … Continue reading

Posted in Disaster Recovery, High Avaliability, Log Shipping, Transaction Log, What I learned today | Tagged , | Leave a comment

Mirroring

As discussed about Disaster Recovery and High Availbility topic here continue on this. today would like to discuss some more information about mirroring. As stated in my ealier post about mirroring, today I would like to write about how to conifigure … Continue reading

Posted in Disaster Recovery, General, High Avaliability, Installation, Tool, Webcast, What I learned today, Whitepapers | Tagged | Leave a comment

HA and DR Techniques in sql server

High Availability and Disaster recovery Techniques in sql server This blog is the introduction and brief overview for high availability and Disaster recovery techniques available in sql server, and its my understanding on it. I will write detail blog on … Continue reading

Posted in Backup and Restore, Disaster Recovery, General, High Avaliability, Tool, What I learned today, Whitepapers | Tagged | Leave a comment