Database Backup in SQL Server

Backup database

The backup of a database is one of the most usefull tasks for database administrators.

Simple script for backup of a database to disk drives

I have Adventureworks2008 database in my SQL Server 2008.

Syntax for backup database

 

BACKUP DATABASE << Databasename >> TO DISK =<<Filename>>

Script for backup database

BACKUP DATABASE AdventureWorks2008 TO DISK='C:/AdventureWorks2008.BAK’

When we run the preceding query the database is backed up to the C drive with the AdventureWorks2008.BAK file name.

When we observe the C drive:

Backup the database with Object Explorer

Step 1

Right-click on the database. Go for tasks and click on "Back Up...".

Step 2

 

Observe the following in the preceding screen shot:

• Database: Adventureworks2008 is the name of the database that you backed up
   
• Bakup type: backup type is the type of the backup (in the preceding screen shot the type of backup is Full)
   
• Name: Name of the backup of the databse
   
• Destiation: where the database backup is stored onto disk drives

Step 3: Click on the “OK” Button

After clicking on the OK button the databse is backed up onto the C drive with 100% success.

Learn something new every day. We will learn 365 new this in the year: pinel Dave Sir