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.