How to Create Database Backup in SQL Server

In this article I am going to explain how to create database backup in SQL Server.
  • 1693

Introduction

In this article I am going to explain how to create database backup in SQL Server.  In SQL server we can make database backup using Enterprise Manager.  To create a database backup, SQL server dialog box is used. In this dialog box we need to put need to put name and description of database backup.  

Steps to create database backup using Enterprise Manager in SQL server

Step 1 : Start SQL server :

Clipboard01.jpg

Step 2 : Expend database and select database => Right click on selected database => Now click on Task => Then click on backup :

Clipboard02.jpg

Step 3 :  Backup dialog box appear  to create database backup :

Clipboard03.jpg

Step 4 : Now verify database or select different database in database list box  :

Clipboard05.jpg

Step 5 : Now select backup type from backup list box. There are three type of backup :

Clipboard06.jpg

Step 6 : Now select backup component :

Clipboard07.jpg

Step 7 : Now put name of backup database and their description :

Clipboard08.jpg

Step 8 : Now Specify when the backup set will expire :

Clipboard09.jpg

Step 9 : Now click on option to change other setting like override media, reliability, transaction log  :

Clipboard10.jpg

Step 10 : Now click on "OK " to complete the process :

Clipboard11.jpg

Step 11 : Now You will show that database backup successfully completed :

Clipboard12.jpg


© 2019 DotNetHeaven. All rights reserved.