How to restore database in SQL Server 2005

I will discuss how to restore database in SQL Server 2005, by the very simple way.
So let’s start:

1. Run  SQL Server Management Studio.

2. In Object Explorer, choose Databases , right click and choose Restore Database…

3. In the new window, select the database name which you want to restore (my database name is MariamDB).

4. On the same window, in Source for restore section, choose From device option, and click browse button.

5. In Specify Backup window, click Add button.

6. Choose the destination where your backup(.bak) file exists, and click OK.

7. Picture should look like this:

8. Check the row, which is showing your backup file information.

9. Go to the options, and check Overwrite the existing database, and click OK.

That is all! 🙂