Previous Code Entry
Left Arrow
SQL Server How to get the number of Characters from a string in a column
Current Code Entry
Next Code Entry
SQL Server Management Studio - Change Recovery Model to Simple
Right Arrow
SQL Server Management Studio - Restore database
Article Entry Date: July 10,2022 @ 01:47:49 / Last Updated On: July 10,2022 @ 01:47:49
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 below code and click [Execute]

RESTORE DATABASE DatabaseName FROM DISK = 'I:\SQLBackup\01-26-2021\DatabaseName.bak'
WITH RECOVERY
GO