Using SQL Query Window:
Use WITH REPLACE option with the RESTORE command on MSSQL query window. Change database name and backup file location as per your setup.
Advertisement
USE MASTER GO RESTORE DATABASE MyDB FROM DISK = 'C:\Backups\MyDB_15082016.bak' WITH REPLACE GO