Overview
Creating backups for SQL Server is very easy. There are a few things you need to consider:
How will you create the backups:
- T-SQL commands
- Using SQL Server Management Studio
- Creating maintenance plans and
- Using third party backup tools
What options will you use
- Backup to disk or to tape
- Types of backups; full, differential, log, etc…
The next two topics cover the basics on how to create backups using either T-SQL or SQL Server Management Studio.
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.
