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 times
Join today, and add this to your favorites.
Coding Source - Share on MySpace Coding Source - Share With Facebook Coding Source - Share on Twitter Coding Source - Share on Reddit Coding Source - Share on Digg It Coding Source - Share on Stumble Upon It Coding Source - Share on Delicious
Share With Friends (Updated 6-8-2010)

Supported Files
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]

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