How to Backup an SQL Server Database using Management Studio

May 26, 2017 / MySQL

Follow the steps mentioned below to take a backup of SQL Server Database using Management Studio.

  1. Open your Microsoft SQL Server Management Studio, whichever you select, standard or express edition.
  2. Using your Database Username and Password, just login to your MS SQL server database.
  3. Select the database >> Right-click >> Tasks >> Back Up:
    STEP1
  4. The following Backup Database window will appear after you click on the “Backup“.
    STEP2
  5. Select the following options:
    Backup type: Full
    Under Destination, in the Backup to check Disk.
  6. Now, by clicking on the “Add” button to select the destination path and file name for the database backup file. You can change the destination path what you want to save:
    STEP3
  7. Select the destination folder for the backup file and enter the “File name” with .bak extension:
    STEP4
    Ensure you put your SQL database .bak file under the MSSQL backup folder.
  8. Click the OK button to finish the backup process of your MS SQL Server Database. You will see the confirmation window with a message “The backup of database ‘SQLDatabaseName’ completed successfully“.
    STEP5

Take a look at how to Restore MS SQL Server Database Backup File

Spread the love
Dominos Search