HOW TO RESTORE DATABASE BACKUP IN SQL SERVER

Step 1: First, we will create a new database with name as "NEWTESTDB". Please see the screenshot as below:

Step 2: Right click on the database name i.e. NEWTESTDB > Tasks > Restore > Database.

Step 3: You will see new window will be open and then select the following options. Please see the below  screenshot as below:

Step 4: Before restore a db backup, we have to do the following changes in Options menu (display at left side) and tick the Overwrite and Restrict checkbox. Please see the screenshot as below:

Step 5: After click on the OK button, the database has restored successfully. Please see the screenshot as below:

  

           - - - - - - Cheers, Happy to Help! - - - - - -