Course curriculum

  • 1

    Introduction

    • 1 - What is a Database? What is a Backup?

    • Project Files and Course Documents
  • 2

    Setting Up The Laboratory

    • 3 - Download Windwos Server 2019

    • 2 - Virtualbox Download and Install

    • 6 - Download and Install SQL Server Management Studio

    • 4 - Add Virtual Machine and Install Windows Server 2019

    • 5 - Download and Install Microsoft SQL Server 2019

    • 7 - Create and Load Sample Databases & Data
  • 3

    Why Should We Take Backup?

    • 8 - What is Backup and Backup Types? (Full, Differential, Transaction Log Backup)
  • 4

    Check in-1

    • 9 - Check in-1
  • 5

    What Is Recovery Model?

    • 10 - What Is Recovery Model And Types? ( Full, Bulk Logged, Simple )
  • 6

    What Should Be The Backup Strategy?

    • 11 - What Should Be The Backup Strategy?
  • 7

    Full Recovery Model and .bak File

    • 12 - Let's Do The First Backup(Full Recovery Model - Full Backup With .bak File)

    • 13 - Differential Backup With .bak File

    • 14 - Transaction Log Backup With .bak File
  • 8

    Restored Full Recovery Model -.bak File

    • 15 - Restore Full Backup With .bak File

    • 16 - Restore Differential Backup With .bak File

    • 17 - Restore Transaction Log Backup With .bak File
  • 9

    Full Recovery Model-Backup Device

    • 18 - Full Backup With .bak File

    • 19 - Differential Backup With .bak File
  • 10

    Check in-2

    • 21 - Check in-2
  • 11

    Restored Full Recovery Model-Backup Device

    • 23 - Restore Differential Backup With Backup Device

    • 24 - Restore Transaction Log Backup With Backup Device

    • 22 - Restore Full Backup With Backup Device
  • 12

    Simple Recovery Model-.bak File

    • 25 - Full Backup With .bak File

    • 26 - Differential Backup With .bak File
  • 13

    Restored Simple Recovery Model-.bak File

    • 28 - Restore Differential Backup With .bak File

    • 27 - Restore Full Backup With .bak File
  • 14

    Simple Recovery Model-Backup Device

    • 29 - Full Backup With .bak File

    • 30 - Differential Backup With .bak File
  • 15

    Restored Simple Recovery Model-Backup Device

    • 32 - Restore Differential Backup With Backup Device

    • 31 - Restore Full Backup With Backup Device
  • 16

    Bulk Logged Recovery Model-.bak File

    • 33 - Full Backup With .bak File

    • 34 - Differential Backup With .bak File
  • 17

    Restored Bulk Logged Recovery Model-.bak File

    • 36 - Restore Differential Backup With .bak File

    • 35 - Restore Full Backup With .bak File
  • 18

    Bulk Logged Recovery Model-Backup Device

    • 37 - Full Backup With .bak File

    • 38 - Differential Backup With .bak File
  • 19

    Restored Bulk Logged Recovery Model-Backup Device

    • 40 - Restore Differential Backup With Backup Device

    • 39 - Restore Full Backup With Backup Device
  • 20

    Restored Deleted Database

    • 41 - Database Full Backup Restore Operations For A Deleted Database
  • 21

    Restore Point in a Time

    • 42 - Restore Point in a Time
  • 22

    Check in-3

    • 43 - Check in-3