mssqltips logo

Create backup using SQL Server Management Studio SSMS



By:
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
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

 

 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 09, 2017 - 4:36:13 PM - Ibrahim Ahmed Back To Top

Thanks for this tips and help 

 



download





get free sql tips

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