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


Create backup using SQL Server Management Studio SSMS


Creating backups using SQL Server Management Studio is pretty simple as well.  Based on how simple the T-SQL commands are, there is a lot of clicking that needs to occur in SSMS to create a backup.


The following screen shots show you how to create a full backup and a transaction log backup.

  • Expand the "Databases" tree
  • Right click on the database name you want to backup
  • Select "Tasks" then "Back Up..." as shown below
backup database from ssms
  • Specify the "Backup type"; Full, Differential or Transaction Log
select backup type
  • Click on "Add..." to add the location and the name of the backup file
  • Click "OK" to close this screen
enter backup destination
  • And click "OK" again to create the backup
select backup options

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.


Friday, March 10, 2017 - 12:33:17 PM - Greg Robidoux Back To Top

You can schedule a backup using SQL Agent or Windows Task Scheduler.  You will need to use the T-SQL BACKUP commands to do this.

See this page: https://www.mssqltips.com/sqlservertutorial/20/sql-server-backup-database-command/


Friday, March 10, 2017 - 11:21:57 AM - Bouslama Back To Top



Thanks a lot for these tutos.

But i want to know how could i plan an automatic backup at a specified time of a day.

Best regards,

Thursday, March 09, 2017 - 4:36:13 PM - Ibrahim Ahmed Back To Top

Thanks for this tips and help 


Learn more about SQL Server tools