Overview
There are primarily two commands that are used to create SQL Server backups. Which are:
These commands also have various options that you can use to create full, differential, file, transaction log backups, etc. as well as other options to specify how the backup command should function and any other data to store with the backups.
Greg Robidoux has been working with databases for 35+ years with extensive hands on SQL Server experience from version 6.5 to 2025. He has authored over 250 technical articles and delivered several presentations online and at various conventions. Greg is also the President and founder of Edgewood Solutions, a technology services company delivering services and solutions for Microsoft SQL Server.
