Take Database Backup in SQL Server 2008 using Query or Management Studio

To take database backup from sql server we have different methods

       1.    With Query

       2.    Directly from sql server management studio

With Query to take database backup:

To take database backup by using sql server query we need to write the query like as shown below

Syntax of Query to take database

BACKUP DATABASE DatabaseName TO DISK ='PATH TO STORE'

Example:

BACKUP DATABASE MySampledb TO DISK ='E:\mysampledb.bak'

Once we run above query we will get output like as shown below and it create database backup in respective folder path

If you check your folder path database backup file will exists.

Directly from SQL Server Management Studio

To take database backup directly from sql server management studio we need to follow below steps

Open sql server management studio à Select your database à Right click on it and select Tasks in that select Backup and click on it like as shown below

Whenever you click on Back Up option it will open new window in that keep Backup type as full and add destination folder path to save backup file for that click on Add button to add destination folder path like as shown below

Now select destination folder path and give file name like as shown below and click OK

Once we add our destination folder path that will be like as shown below

Now click OK it will create database in your destination folder check it….