Knowledge Base
MilesWeb / Database

How to Backup an SQL Server Database?

Approx. read time : 2 min

To cope up with the data loss situations like hardware failure, network intrusions, human errors, natural calamities, etc. you should always take a backup for your SQL database.

Microsoft Server Management Studio Express is a free and open source graphical management tool that can be used to manage your SQL database.

To back up your SQL database using Microsoft SQL server management Studio Express you should make sure that:

1) You must have direct access to the local server desktop.

2) You must have Microsoft SQL Server Management Studio Express installed and running on the server prior to the export.

The backup file that you download needs .bak file extension. If the database is stored on the shared servers, then the backups get generated on the server itself. You may contact your windows support team to get the copy of the backup.

Method 1 –

Steps to follow to take a backup of SQL server database :

 Step 1: First, of all, you will need to configure the Microsoft Server Management Studio on your local machine.

Step 2: Open your Microsoft SQL Server Management Studio, Standard or Express edition whatever you prefer.

Step 3: Enter your database Username and Password to login to your MS SQL server database.

Step 4: Expand database.

Step 5: Right click on the database you want to take backup. Database -> Tasks -> Back Up

image 1

Step 6: The Back Up Database window will appear on your screen. Now select the following options on it :

  1. Backup type: Full
  2. Under Destination -> Backup to : Disk

image 2

Step 7: Click Add. Now you can see the following window that will appear on your screen. Select the desired path and file name for the database backup file.

Step 8: Select the destination folder where you like to store the backup. Enter the File name with .bak extension

image 3

Important: Make sure that you place your MS SQL database in the .bak file under the MSSQL backup folder.

Step 9: Click on OK to finish your backup. Once done with this, the message will appear showing your successful completion of database backup process. The confirmation window will show you the message that “ The backup of database ‘yourdatabasename’ completed successfully”.

image 4

Hurray!

Your backup is completed.

Related: A Complete Guide to SQL Injection

Method 2 –

The BACKUP DATABASE allows you to take the complete backup of your database and files, differential, etc. backups. This depends on the option that you like to use.

Let’s see the commands to be used to take backup:

To Create a full backup to disk

 BACKUP DATABASE – Give the database name with this command.

TO DISK – It specifies that the backup would be written to the disk. Specify the location and file.

image 5

To Create a differential backup

 In this command, you just need to add “WITH DIFFERENTIAL” option as shown below.

image 6

That’s it.

Taking backup is very easy by just using these two commands.

With an interest in doing something creative daily, Sonam works as a Digital Marketing Executive. She likes to write technical blogs related to web hosting, digital marketing, and other IT topics. She also likes to spend her leisure time on social media to find different strategies for client engagement.

Trusted By Thousands of Clients & Big Businesses

We highly appreciate the kind and stellar feedback we receive from our customers. Delivering the best is our goal! MilesWeb is rated Excellent out of 5 based on reviews. Read more reviews.

Excellent
Based on reviews
2 hours ago
Perfect and Valuable Server + ...
I am using MilesWeb Servers, The main thing which I getting are continuous support over everything w...
Gunjan Makwana
4 hours ago
Milesweb is superb Hosting pro...
Milesweb is superb Hosting provider ever, their Support team is amazing!!!...
Abhishek Singh
15 hours ago
Great support in great timing...
We need urgent assistance on changes in a primary domain on our client's Cpanel accounts and reached...
Riyaju Deen
21 hours ago
Best Website Hosting platform ...
I was new on MilesWeb. And needed help on multiple areas from setting up to getting started with cre...
Harshada
1 days ago
Very quick and helpful assista...
Very quick and helpful assistance. Support person listened properly and provided a nice solution....
Narendra
1 days ago
the team is very supportive th...
the team is very supportive though at times effort needs to be made to make understand the problem s...
Suree Sharma
1 days ago
I am using miles web for 3plus...
I am using miles web for 3plus years, very quick and perfect support by the team, they helped me man...
Sri Raghav
2 days ago
The service is good...
The service is good. They are answering with patience and doing the needful as soon as possible....
MR
2 days ago
Perfect and Valuable Server + ...
I am using MilesWeb Servers, The main thing which I getting are continuous support over everything w...
Gunjan Makwana
3 days ago
Very quick and helpful assista...
Very quick and helpful assistance. Support person listened properly and provided a nice solution....
Narendra
4 days ago
positively helped me with find...
positively helped me with finding insecure content on my website causing SSL to not work properly on...
Thaviraj Junglee
4 days ago
Exceptional support, Truly Pra...
I had opted for the basic wordpress hosting plan as I intended to experiment with various plug-ins. ...
Aseem Chandna