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.