Create backup using SQL Server Management Studio SSMS

Overview

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.

Explanation

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

Specify the "Backup type"; Full, Differential or Transaction Log

Click on "Add..." to add the location and the name of the backup file
Click "OK" to close this screen

And click "OK" again to create the backup

Last Update: 3/12/2009

<< Previous

Next >>

Comments For This Article

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

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

Hi,

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 9, 2017 - 4:36:13 PM - Ibrahim Ahmed

Thanks for this tips and help