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

Finding List of Tables Using View in MS SQL

Finding Session Id in MS SQL User's Current Process

What is the Maximum Number of Columns a Table in SQL Server ?

What is a ROLLUP Clause in SQL Server ?

MS SQL Getting a Random Row in a Table