• 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…

  • Internals

    sql server internal architecture

      Database Physical Structure & Internals: SQL server internals Allocation Map is important for DBAs. It will help to understand the database internals. Database: A Database is a collection of data that is stored (or) organized. We can manage and access data easily. When we create a new database, by default two files will be created physically. We can create more than one log files and data files (NDF). Data file (MDF) Log file (LDF) Data File: All the data will be stored in a data file. Internally the data’s are stored in data pages. A database file has unique FileID and PageID. Log files do not have pages. They have…