Wednesday, September 26, 2018
Home > SQL Server > How to Backup a Database using SQL Management Studio

How to Backup a Database using SQL Management Studio

SQL Backup

How to Backup a Database using SQL Management Studio

I will do it in steps with screenshots for better understanding.

First we need to connect to the Database Server from where we need to take backup of database.

STEP – 1

You need Server name, Authentication, Login and Password. As in my case I have filled the required credential to log in to my local Database Server. Please refer Image – 1 

How to Backup a Database using SQL Management Studio
Image – 1

STEP – 2

After successfully connected to the Database Server, you will see all the database there, then select and right click on the database you want to take backup then select Tasks > Backup. Refer to Image – 2

How to Backup a Database using SQL Management Studio
Image – 2

STEP – 3

From the Backup database page select location for backup destination by clicking on Add and write the file name to save the backup file like (database.bak) Refer to Image – 3.

How to Backup a Database using SQL Management Studio
Image – 3

STEP – 4

Here one thing need to take care like there should not be two backup locations in the list.. if so then remove one and keep only one backup destination as per the Image – 4.

How to Backup a Database using SQL Management Studio
Image – 4

STEP – 5

Once after selecting backup destination click Ok to start taking backup and for successful backup you will see the page . Check Image – 5

How to Backup a Database using SQL Management Studio
Image – 5

Hope this is going to help how I have explained to backup Database using SQL Management Studio and to save it in  .bak sql database backup file in Windows machine. Step by Step walk through with screenshots.

You may like: How to Restore a Database using SQL Management Studio

Durga Charan Ojha
I am a proud Indian, proud father, a blogger, Being in a profession as System administrator, my passion is troubleshooting computer issues, I do like sharing solutions through blogging making videos of solving issues.
https://lifeonnetwork.com/

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.