Restoring MS SQL database with management Studio
To restore a database we can follow two below mentioned procedure to restore the database.
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:
Article ID: 1232
Last updated: 26 Jul, 2020