SQL Backup and Restore

To take a backup of your database, do the following:

Launch SQL Server Management Studio (SSMS) and connect to your SQL Server instance.
Expand the Databases node from the left-pane aka Object Explorer.
Right-click the database that you wish to backup, hover over Tasks, and select Back up....
On the General page in the Destination section select Disk from the Back up to: drop-down list.
Select Remove until all existing backup files have been removed.
Select Add and the Select Backup Destination dialog box will open.
Enter a valid path and file name in the File name text box and use .bak as the extension to simplify the classification of this file.
Click OK and then click OK again to initiate the backup.
When the backup completes successfully, click OK to close the SQL Server Management Studio dialog box.

To restore your database, do the following:

Launch SQL Server Management Studio (SSMS) and connect to your SQL Server instance.
Right-click the Databases node in Object Explorer and select Restore Database... as shown in the below image.
On the General page, use the Source section to specify the source and location of the backup sets to restore. Select Device:, and then select the ellipses (...) to locate your backup file.
Select Add and navigate to where your .bak file is located. Select the .bak file and then select OK.
Select OK to close the Select backup devices dialog box.
In the Destination section, the Database box is automatically populated with the name of the database to be restored. To change the name of the database, enter the new name in the Database box.
Select OK to restore the backup of your database.