I want to restore an SQL database from backup created on a different SQL Server installation. I don’t want to use command prompt for this. Is there any other way to restore database in SQL Server and how to do it?
Using Command Prompt may not be preferred for the task at hand for many reasons. Fortunately, there is a very simple method by using SQL Server Management Studio. Copy the SQL Backup file to a local hard-drive. Launch SQL Server Management Studio and login to the SQL server where the database has to be restored. Select Restore database after right clicking on the Database folder. From the ‘Source for restore’ section, choose ‘From Device’. Choose ‘File’ as the backup media and then click on Add button. Choose the SQL backup file after browsing and then click on OK.
The Restore Database dialog box will appear where you need to select the target database where you want your backup recovered. The data will be replaced with the backup if you choose an existing database. You can also create a new database and restore the backup in that by typing the new name. Choose the restore point that you would like to use. Multiple restore points might be listed because an SQL backup file can store multiple backups.
The database will be restored.
