In this lesson, we will restore a database from a backup in SQL Server Management Studio.
Open SQL Server Management Studio.
Right-Click on the database.
Choose [New Query]
Paste the code below and click [Execute]
RESTORE DATABASE DatabaseName FROM DISK = 'I:\SQLBackup\01-26-2021\DatabaseName.bak'
WITH RECOVERY
GO