SQL SERVER DATABASE BACKUP AND RESTORE DATABASE
Step 1: Right click on the Database Name-> choose Tasks -> click on back up. Step 2: Click on Add button to create a database file. Step 3: Choose the Location where do you want to save your backup file. Step 4: After inserting a name of your backup file click on ok. You will get the following message box. Step 1: Right click on Database -> select Restore Database. Step 2: Choose the Radio button “From device”. then click on the button to get the database backup file. Step 3: Click on the ‘Add’ Button to get the database backup file. Step 4: Choose the database backup file that you want to restore. Step 5: After selecting you click on ‘Ok’ button. Then you need to check the ‘Restore’ button. Then click on ok. Step 6: You can see the following window.