SQL server supports three main types of backup:
Each of these types has several variants and we will go through each of them.