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.

3. Click on Device and select the backup file.

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

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

6. Once you were done, Click OK
7. The following message will display

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