How to create a SQL Server backup


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.

Comments For This Article

get free sql tips
agree to terms