- By iboard
- /
- 2020-06-04
![](assets/images/blog/blog-details.png)
Apply backup file to MSSQL server
Step 1
Before restoring a database, you can delete the existing database or overwrite the existing database. Here we want to remove the database and restore it as a new database.
To restore a database, right-click on the database -> select Restore Database.
Step 2
Now a new dialog window will appear to restore your backup file.
note
Mention the database name exactly in the “As database” field. very important.
Step 3
After filling the database name, select the database or database backup file from your device. Here, you have the file on your device. Please kindly select it from your device options. Now a new dialog window will appear allowing you to add backup files from your device to SQL Server.
Step 4
When you click Add, a new dialog window will appear and ask you to select a directory and backup file.
After completing all the above steps, you have now added your backup files using the checkbox option in the box.
Here you need to confirm the selected backup file.
;