Contact Form

Name

Email *

Message *

Follow on LinkedIn
Image

How to Backup and Restore Database in MS SQL Server?


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
Connect Database Engine

3. Select the database you want to Backup
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
Right Click, Select Tasks and Backup

6. Now, Click on OK Button.
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
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
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
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
Click on Add Button
8. Then, Select the database you wan to restore and click on OK
Select the Database you want to restore
Select the Database you want to restore

9. Again Click on OK couple of times.
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
Final Window, Click on Ok Here
11. Restore Successful message will open here as shown in the figure below
Restore Successful Message
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!




Comments