By: Greg Robidoux
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](/tutorialimages/25_SSM1.jpg)
- Specify the "Backup type"; Full, Differential or Transaction Log
![select backup type](/tutorialimages/25_SSM2.jpg)
- Click on "Add..." to add the location and the name of the backup file
- Click "OK" to close this screen
![enter backup destination](/tutorialimages/25_SSM3.jpg)
- And click "OK" again to create the backup
![select backup options](/tutorialimages/25_SSM4.jpg)