Previous Article SQL Server How to get the number of Characters from a string in a column |
SQL Server Management Studio - Restore database |
Next Article SQL Server Management Studio - Change Recovery Model to Simple |
Coding Article #: 1085 - Published On: February 13, 2021 @ 03:37:47 AM - Last Updated on: February 13, 2021
This article has been Favorited 0 timesJoin today, and add this to your favorites.
Share With Friends (Updated 6-8-2010)
Supported Files
No Files for this Article.
No Files for this Article.
No Screenshot Available
In this lesson, we are going to 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]
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
Post to Facebook about: SQL Server Management Studio - Restore database