Backup SQL Server database using Management Studio

Introduction

In this article I will explain how to backup an SQL Server database using SQL Server Management Studio (SSMS)

Step 1: Open SQL Server Management Studio image001

Step 2: Login with your credentials

image002

Step 3: Expand Databases node in the Object Explorer. And right click on the database you want to back up. Then select Tasks -> Back Up

image003

Step 4: Select backup type as Full and destination as Disk as we want to create a full backup and want to save it on the local disk. Then click on Add to add backup location.

image005

Backup type can be Full or Differential. Backup destination can be Disk or URL. URL destination is selected when you want to store backup on Windows Azure Blob storage.

Step 5: In the Select Backup Location dialog box, select backup location, enter file name as “AnyName.bak” and click OK thrice to complete the backup.

image008

Step 6: You can view the backup(.bak file) at the location specified

image010

Leave a Reply

Your email address will not be published. Required fields are marked *