Table of Contents
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.
Create backup using SQL Server Management Studio SSMS
The following screen shots show you how to create a full backup.
- Expand the “Databases” tree
- Right click on the database name you want to backup
- Select Tasks then Back Up… as shown below
![Bg094](https://bonguides-1e199.kxcdn.com/wp-content/uploads/2022/05/bg094.png)
2. Specify the Backup type: Full or Differential.
![Bg095](https://bonguides-1e199.kxcdn.com/wp-content/uploads/2022/05/bg095.png)
By default the backup files are saved in this location C:\Program Files\Microsoft SQL Server\MSSQL12.INSTANCENAME\MSSQL\Backup.
3. Click on to add the location and the name of the backup file as you need.
![Bg099](https://bonguides-1e199.kxcdn.com/wp-content/uploads/2022/05/bg099.png)
4. Click OK to save the changes then start backup. It could take a while depending on the size of the database.
![Bg097](https://bonguides-1e199.kxcdn.com/wp-content/uploads/2022/05/bg097.png)
5. When the backup task is completed, you can navigate to the backup destination location to verify it works.
![Bg100](https://bonguides-1e199.kxcdn.com/wp-content/uploads/2022/05/bg100.png)
5/5 - (1 vote)