• DR/HA,  SQL party

    SQL server Disaster Recovery plan

    SQL server Disaster Recovery Options This month’s TSQL Tuesday party is being hosted by Allen Kinsel (Blog | Twitter) and the topic this month is disaster recovery. It’s a DBA Topic/Job.   The disaster recovery is really “It depends”. What is disaster recovery? Disaster recovery is called DR. Hmm… Disaster recovery is the best option for the business to minimize their data loss and downtime. The SQL server has a number of native options. But, as I already told everything is depends upon your recovery time objective RTO and recovery point objective RPO. That is how much data can you afford to lose? How long can you wait? How much money…

  • Backup/Restore,  Basics for freshers,  Internals

    SQL server Recovery Models and Backup types

    In this post I am going to explain the importance of recovery models and backup types. Why I am writing this post ? Because, when I was teaching about the topic to my PHP friend .He got doubts on bulk logged recovery model and differential backups. I have given some examples and cleared his doubts. I am going to share this with you guys too. I hope this will help for Freshers and DBA managers. Recovery models and backup types are important to plan the recovery point objective (RPO) and recovery time objective (RTO). We can’t differentiate the recovery models and backup types. Simply, it’s a mixture. Let’s see the discussion. Manager: We need minimum data…