Restoring MSSQL database with Management Studio

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 T-SQL

To Restore SQL DB manually using following steps-

This command will help to restore the DB from .BAK file:

RESTORE DATABASE CMDB FROM DISK = ‘C:\CMDB.BAK’

Restore SQL database using SQL Server Management Studio

If the above method doesn’t work, use SQL server management studio which configures, manages and administers all components within SQL server. SQL server management studio is part of the licensed SQL database version and consists of script editors to act upon the corrupt database and resolve possible errors.

Follow below-listed steps to restore SQL database backup:

  1. Connect to the instance of MS SQL server database and go to Object Explorer. Expand the server tree by clicking on the server name
  2. Go to Databases and right-click on databases, followed by Restore Database.

  1. Click on Device and select the backup file.

  1. Select backup device Window will appear, click on Add.

  1. Locate Backup file Window will appear, Select your backup file (CMDB.bak).

  1. Once you were done, Click OK
  2. The following message will display

  1. Refresh the database. Now you can see the restored database(CMDB) in Object Explorer.



    • Related Articles

    • 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 connect to MSSQL Server from local SQL Server Management Studio

      This article will guide you on how to connect to MS SQL Server from your local SQL Server Management Studio. You can obtain login details from VPS setup mail or by sanding a request to our support mail-id i.e. support@diadem.in from your registered ...

    • Delete MSSQL Server DB from SQL Management Studio

      How to Delete a SQL Server DB from management studio Before we begin we must know about Limitations and Restrictions while deleting a database from SQl server DB. System databases cannot be deleted. Prerequisites Delete any DB snapshots that exist on ...

    • 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 ...

    • 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.