How to Backup and Restore Database in MS SQL Server?

How to Backup and Restore Database in MS SQL Server?

Sometimes, we need to Back up Database for Security as well as mobility (to move database from on machine to another) purpose.
And to use the others or our own application we might need to create database and save in our machine. And if the database is already created then it can be used easily by simply restoring the database file.
Thus, in this blog post I'll show you how to Backup and Restore database in MS SQL Server 2014.

A. How to Backup Database in MS SQL Server 2014?

1. Open SQL Server Management Studio
2. And Connect Database Engine by selecting the user and click on Connect

Connect Database Engine

3. Select the database you want to Backup

Select The Database You Want to Backup

4. Right Click and Select Tasks
5. Then Select Backup

Right Click, Select Tasks and Backup

6. Now, Click on OK Button.

Now Click on OK Button

7. Backup Successful message will popup as shown in the figure below

Database Backup Successful Message Popup

Finding the Backed Up Database File

1. Go to Local Disk C ( or the partition where MS SQL Server is installed )

2. Then go to Program Files

3. And Find Microsoft SQL Server folder.

4. You'll see multiple folders but select the last one (Open the Last Folder)

5. Now open, MSSQL folder.

6. Then, open Backup folder.

7. Here you'll find all the database you've backed up.

B. How to Restore Database in MS SQL Server 2014?

1. Copy the backup file (file with .bak extension)
2. And Paste it to Backup Folder
3. Now, Go to SQL Server Management Studio
4. Right Click on Databases
5. Then Click on Restore Databases

Right Click and Select Restore Database

6. Select the Device Radio button and then click on three dot icon as shown in the figure

Select the Device Radio button and Then Click on three dot icon on the right

7. New pop up will be shown, click on ADD button here

Click on Add Button

8. Then, Select the database you wan to restore and click on OK

Select the Database you want to restore

9. Again Click on OK couple of times.

Click on Ok Couple of Times

10. Finally the following form will open, select OK button here as well.

Final Window, Click on Ok Here

11. Restore Successful message will open here as shown in the figure below

Restore Successful Message

The Video for "How to Backup and Restore Database?" is as follows

You can begin the "Beginners Guide to Database using MS SQL Server" course for free from the link below


If you like this post then don't forget to LIKE, SHARE and SUBSCRIBE to YouTube Channel.
Thank You!