You just need to click on the OK button to restore the database. And, information of the selected backup file will be added in the Backup sets to restore section.įigure 6 – Backup File in Restore Database WindowĪll the information needed to restore the database from backup file has been entered. Step 6: The name of the database to be restored is displayed in the Database box under Destination section. Again click OK to return to the 'Restore Database' window.įigure 5 – Selected Backup File in Specify Backup Window.Again click OK to return to the Restore Database window.įigure 2 - Locate SQL Database Backup Fileįigure 3 – Select Add to Navigate to.BAK file you want to restore, and then click OK. From ‘Select backup devices’ window, choose File as backup media, and then click Add.Choose the Device option, and then click the ellipses (.) to find your backup file. However, you can manually specify the database file or device by selecting the Device option.ī. Note: When the backup is taken from another server, the destination server won’t contain the backup history information for the selected database.
Choose the Database option, and then select the database you want to restore from the drop-down list. From the General page, under Source section, select any of these options:Ī. Step 5: The Restore Database window is displayed. Step 4: Right-click the Database, and then click Restore Database. Step 3: Navigate to Databases and open the database you want to restore in SQL Server. Step 2: Next, go to Object Explorer and click the Server Name to expand the Server tree.
Step 1: Open SSMS and connect to an instance of SQL Server. If you have SSMS installed on your system, follow these steps to restore your SQL database from the backup (.bak) file: Method 1 – Restore SQL Database using SSMS Methods to Restore SQL Server Database from. When you want to restore a db from another server instance, you will need to manage metadata to make the db available on another server.This is because, if the active transaction log (also referred to as the tail of the log) becomes unavailable, all transactions in that log will be lost.
While rebooting the SQL server may resolve the problem in some cases, using a backup (.bak) file is the most feasible option to restore SQL database (db). Such errors can render a database unusable.
Many SQL Server Database Administrators (DBAs) struggle repeatedly with errors like abrupt termination, database connection or transient errors, problem with drivers, malicious software attack, etc.