Take Full backup of MS-SQL database using management studio

Take Full backup of MS-SQL database using management studio

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.



    • Related Articles

    • Restoring MSSQL database with Management Studio

      Restoring MS SQL database with management Studio To restore a database we can follow two below mentioned procedure to restore the database. Restore SQL database using T-SQL Restore SQL database using SQL Server Management Studio Restore SQL DB using ...

    • How To Restore a Microsoft SQL Database Backup Using SQL Server Management Studio

      Steps to Restore a Microsoft SQL Database Backup Using SQL Server Management Studio. Open SQL Server Management Studio and Connect to the SQL Server you want to restore the database to. Once you Connected to the SQL server, right click on the ...

    • Backup and restore MySQL database with Plesk

      Backup and restore MySQL database with Plesk Description: In Plesk, database dumps are created in the SQL format and saved as ZIP archives. If you need to create a dump in another format or to set custom settings for a dump, use the native ...

    • How to Create MS SQL Database Through SQL Server Management Studio

      This article will assist you to create MS SQL database through SQL Server Management Studio. 1. Open Run box by pressing Windows key + R. 2. In Run box type SSMS and hit enter. This will open connect to server window.

    • How to download website backup using plesk control panel

      Steps to download website backup using Plesk Step 1: At first login to the Plesk control panel and click on Website & Domains then select the domain for which you want to take the backup and then go to file manager. Step 2: Select the folder (or ...