How to Backup SQL Database using SSMS

How to Backup SQL Database using SSMS

In this tutorial I will teach you how to Backup SQL Database with your SQL Server Management Studio (SSMS). This will save you from losing your data in case of any SQL Server problem.

SQL Database Backup Steps

The following steps explain how to do Full Backup of your database using SSMS.

STEP 1: Expand the Database node

Click the plus sign in-front of the Databases node. This will show all the databases.

databases node
Restore Database SQL Server – Check this related tutorial which outlines complete steps of the procedure.

STEP 2: Select Backup Option

Right click on the database you want to backup then select Tasks > Back Up. This will open the Back Up Database window.

select backup option

STEP 3: Select the Backup Type & Backup Destination

In the Back Up Database window there are 3 options for the Backup typeFull, Differential & Transaction Log.

Select the Full one.

CRUD operations in SQL Server is the first most tutorial you should read before starting with SQL Server.

On the Destination area you will see the Backup destination is already provided by the SQL Server. This location is:

C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup.
If you want to change this location then click the Remove button to remove it and then click the Add button to select a new destination.


backup database window

Finally click the OK button to Backup your database.

database backup file
In SQL Server, other than Backup and Restore of database, there is also an option to Script Database with it’s complete data.


  • linkedin
  • reddit


I hope you enjoyed reading this tutorial. If it helped you then consider buying a cup of coffee for me. This will help me in writing more such good tutorials for the readers. Thank you. Buy Me A Coffee donate