Sql Server : take back up of database

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

Description:
In the previous article I have explained Like linq query example and bind gridview,Server side validation in MVC Razor using data annotation, Populate Dropdown List dynamically using Asp.net MVC Razor, Code First migration in asp.net MVC 4, Populate Cascading Dropdown List in Asp.net MVC4 using Json and Jquery and What is Asp.net MVC? Its advantages and disadvantges.

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.

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:

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:

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:

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.