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.

Post a Comment

[blogger]

MKRdezign

Contact Form

Name

Email *

Message *

Powered by Blogger.
Javascript DisablePlease Enable Javascript To See All Widget