How to Create Database Backup in SQL Server 2012

Introduction

 
In this article, I am going to explain how to create a database backup in SQL Server 2012. In SQL Server 2012 we use Enterprise Manager to create a database backup. The SQL Server dialog box is used to create a database backup. In this dialog box we need to provide the name and description of the database backup.  
 

Create Database Backup in SQL Server 2012

 
Step 1: Start SQL Server
 
Database Backup in SQL Server 2012
 
Step 2: Expand database and select database => right-click on selected database => now click on Task => then click on Backup
 
Database Backup in SQL Server 2012
 
Step 3:  The Backup dialog box appears; to create a database backup
 
Database Backup in SQL Server 2012
 
Step 4: Now verify the database or select a different database in the database list box
 
Database Backup in SQL Server 2012
 
Step 5: Now select the backup type from the backup list box. There are three types of backup
 
Database Backup in SQL Server 2012
 
Step 6: Now select the backup component
 
Database Backup in SQL Server 2012
 
Step 7: Now provide a name of the backup database and description
 
Database Backup in SQL Server 2012
 
Step 8: Specify when the backup set will expire
 
Database Backup in SQL Server 2012
 
Step 9: Specify the destination of the database. To select the destination click on the Add Button
 
Database Backup in SQL Server 2012
 
Step 10: Now we see a new dialog box, click on the browse button to choose the location
 
Database Backup in SQL Server 2012
 
Step 11: Now we again see a new dialog box, choose the location of the backup file and provide the name of the backup file. Then click the OK button
 
Database Backup in SQL Server 2012
 
Step 12: We see that the destination path for the backup file has been selected. If it is correct then click the OK button
 
Database Backup in SQL Server 2012
 
Step 13: Now click on the option to change other settings like override media, reliability or transaction log
 
Database Backup in SQL Server 2012
 
Step 14: Now click on "OK " to complete the process
 
Database Backup in SQL Server 2012
 
Step 15: Now you will see that the database backup has completed successfully
 
Database Backup in SQL Server 2012


Similar Articles