Method 2 – Restore sql server database from. Your SQL database will be successfully restored. Step 9: Click OK when the ‘restore of database completed successfully’ message pops up.įigure 11 - Database Restoration Completed Message Step 8: The window with restore progress is displayed.įigure 10 - Restore Process in Progress Window Step 7: To proceed with the restore process, hit the OK button. You will have to leave it in non-recovered state ready for more backups to be applied, i.e. Note: If you are doing differential or log restore after full restore you cannot leave your database in recovered state. Additional transaction logs cannot be restored.(RESTORE WITH RECOVERY)’. Under the Recovery State section, choose ‘Leave the database ready to use by rolling back uncommitted transactions.If you want to prevent this, create a new database and move the physical file to a new location. Note: Choosing the ‘ Overwrite the existing database (WITH REPLACE)’ option will overwrite your existing db. Under the Restore options section, select the ‘ Overwrite the existing database (WITH REPLACE)’ option.To do so, follow these steps:įigure 7 - Locate SQL Database Backup Fileī. Changing the file settings from the Options page can help overcome any such problem. BAK file created on another SQL Server installation. Such problems usually occur when restoring SQL database from a. bak files store information about the location of data files, and in case of any problems with those files, such as conflicting data file names” or “the destination directory does not exist” can result in an error. 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.
0 Comments
Leave a Reply. |