MS SQL Restoring a Database With a Query

If it is desired to restore (return from backup) of a database that has been backed up in MS SQL Server, the following code is run.

RESTORE DATABASE {Our Database Name} TO DISK= {Path of .bak File to Restore from Backup}

Its usage is as follows..

RESTORE DATABASE OurDB TO DISK='c:\OurDB.bak'

After this process is done, the Databases folder in the Object Explorer (left panel) must be right-clicked and "Refreshed" for the change to be seen.



You May Interest

MS SQL Show Only Date of Current Time

Creating a View in MS SQL

What is a ROLLUP Clause in SQL Server ?

Listing Metadata of MS SQL Server Internal Tables

What is the Filtered Index in SQL Server ?