How to Backup Database through SQL Server Management Studio ?

Step 1

Open your Microsoft SQL Server Management Studio and connect by using your Database Username and Password.

Step 2

Select the database >> Right-click >> Tasks >> Back Up.

Once you click on the “Backup” the following Backup Database window will appear as shown in the image below.

Step 3

Select Backup type as Full.

Step 4

By clicking on the “Add” button the following window will appear to select the path and file name for the database backup file.

Step 5

Select the destination folder for the backup file and enter the “File name” with .bak extension.

Make sure you place your MS SQL database .bak file under the MSSQL backup folder.

Step 6

Hit the OK button to finish the backup of your MS SQL Server 2008 Database.Upon the successful completion of database backup, the following confirmation window will appear with a message “The backup of database “test” completed successfully.​

Following the above steps, you will be able to create a successful backup of your MS SQL Server Database into the desired folder.

Thanking You
Gopal Shekhawat

Our Score
Our Reader Score
[Total: 0 Average: 0]

Leave a Reply