Sql Server : take back up of database - Free Asp.Net,MVC,AngularJs,Jquery,Javascript,Sql Server,WCF,Entity framework snippets and tutorial

Sql Server : take back up of database

Introduction: in this article I will explain How to take back up of database using Sql  Server.

To take up the back up of database follow the given step:


1  1.    Open Sql server and connect to Sql Server.

2  2.       After that expand the databases.
How to take back up of database using Sql  Server

3   3.       Right click on the database that you looking for backup. Here I want to take the back up of DEMO database. Tasks>> Back up. See the attached snapshot:
How to take back up of database using Sql  Server

4   4.       Back up configuration window will be open. On general tab select the database type. You can also change the database for back up.

5   5.       To change the location of Back up file click on add button as mention in attached snapshot:

How to take back up of database using Sql  Server

If you not want to change location than file backup saves to default location:
C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\

6   6.       If you already have the backup of database and want to overwrite existing file. Click on option tab and select the overwrite existing backup option as mention in snap shot:

How to take back up of database using Sql  Server


When backup is complete than you got a successful message.

Is this article helpful for you?
If yes post your comment to appreciate my work and fell free to contact me. You can like me on Facebook, Google+, Linkedin and Twitter via hit on Follow us Button and also can get update follow by Email.

What do you think about this article?

If you found this article useful, please share and follow on Facebook, Twitter, Google Plus and other social media websites. To get free updates subscribe to newsletter. Please put your thoughts and feedback in comments section.

Share this

Share on FacebookTweet on TwitterPlus on Google+


EmoticonEmoticon