Home
About
Contact
Categories
Classic ASP (28 - Sub-Categories)
CSS (1 - Sub-Category)
JavaScript (4 - Sub-Categories)
Databases (22 - Sub-Categories)
ASP.NET (23 - Sub-Categories)
Delphi (5 - Sub-Categories)
Windows Server Core (3 - Sub-Categories)
VMWare (1 - Sub-Category)
Code Editing Tools (2 - Sub-Categories)
Linux (2 - Sub-Categories)
Dell Servers (15 - Sub-Categories)
Bug Reports
(Bugs Fixed
New CFFCS Coding Source is still in Beta
Please report any errors to the [Contact] page. Thank you.
Classic ASP (28)
CSS (1)
JavaScript (4)
Databases (22)
ASP.NET (23)
Delphi (5)
Windows Server Core (3)
VMWare (1)
Code Editing Tools (2)
Linux (2)
Dell Servers (15)
Format SQL Script
Previous Code Entry
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
Databases
SQL Server
SQL Server Management Studio - Restore database
Format Your SQL Script
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
Format Your SQL Script
Tags
restore a database in SQL Server Management Studio
backup in SQL Server Management Studio
SQL Server How to get the number of Characters from a string in a column
