Follow the steps mentioned below to restore a database from a backup file.
- Open your MS SQL Server Management Studio and connect to your database.
- Select the database and Right-click >> Tasks >> Restore >> Database:
- The “Restore Database” window will display. Select “From device” mentioned below the “Source for restore” and click the button in front of that to specify the file location:
That’s it! Now you have restored your SQL server database successfully with confirmation message “The restoration of database ‘SQLDatabaseName’ completed successfully.“.