Previous
Left Arrow SQL Server How to get the number of Characters from a string in a column 		Current Code Entry
 Next
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