How to take backup of SQL Database from SQL Server?

Want to take backup of MDF file from SQL server? Follow steps given below.
Hide All Screenshots

 

STEP 1

image Go to that database under Database folder in Object Explorer window, of which you want to take backup.

 

image Right click on that database, go to Task and select Back up.

 

image
STEP 2

A window will be open. Select Destination path of the back up folder and click on OK.

 

image

STEP 3

Finally it will be prompted that back up is completed successfully.

 

image

STEP 4

Go to the installation folder of the SQL Server where in Backup folder backup of that database will be created as .bak file format.

 

image

Home SysTools FAQs » SQL Server » How to Take Backup of SQL Database
Loading