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 in 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

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 type – “Full”, “Differential” & “Transaction Log”.

Select the Full one.

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

Share this article -

yogihosting

ABOUT THE AUTHOR

This article has been written by the Technical Staff of YogiHosting. Check out other articles on "WordPress, SEO, jQuery, HTML" and more.