Learn more about SQL Server tools

mssqltips logo

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Scripts          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories


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.

Last Update: 3/12/2009

More SQL Server Solutions

Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 

Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.


Learn more about SQL Server tools