Introduction
This article explain the simple way to take the database backup in SQL SERVER which can be easily understandable by the database programmer having little knowledge of DBA. For taking the database backup, we need to follow the given step.Step 1:- Open the SQL Sever Management Studio. For this we have to follow the following path:-
START –> All Programs –> Microsoft SQL Server 2008R2 –> Click on SQL Sever Management Studio (SSMS) –> Open the SQL Server Management Studio using Login information (Username & password or Window authentication )
Please note:-
Above path can be changed depending on the Window version.
Step2:- Once SQL Sever Management Studio is opened, opened the Object Explorer. By default it will be already opened. If it is not opened, then follow the below steps to open it.
Click on the View(Top menu) –> Click on Object Explorer.
Step3:- Under the Databases node, select the database for backup and right click on it. Then choose Tasks and then Back Up.. as shown in the below figure. Here we choose the Company_DB as database.
![]() |
Choose Database for backup |
Step4:- On the click on Back Up… link, it will create a Back Up Database window as shown below:-
![]() |
Back Up Database Window |
![]() |
Backup database Option Screen |