Diadem Technologies Support Knowledgebase

Take Full backup of MS-SQL database using management studio

Article ID: 793
Last updated: 23 Jul, 2018

To take the full backup of MS-SQL database, please follow the below steps

1. Open SQL Server Management Studio and connect to the appropriate instance of Microsoft SQL Server Database Engine in Object Explorer.

2. Expand Databases node and then right click on the database for which you want to take the backup, then go to Tasks → BackUp option as shown in below screen shot. 


3. In backup database dialog box, in database list box, verify the database name. In Bckup Type list box select Full. Once you have taken a full backup of a database then you can perform Differential backup or Transactional log backups. However, if your database is in Simple recovery model you will not be able to take a Transactional log backup.

4. Click the Add button to select the file or backup device for the backup destination as shown in the below snippet and click OK to return to Backup Database Dialog box.

5. Once you have completed the General settings you will be able to see a screen similar to below snippet.

6. Give the name of the backup file with .bak extension.

7. Finally click on OK for three times to take backup.

This article was:  
Report an issue
Article ID: 793
Last updated: 23 Jul, 2018
Revision: 10
Views: 154
Comments: 0