Only databases that have backups on the selected device will Note This list is only available when Device is selected. In the Source: Device: Database list box, select the name of the database which should be restored. After you add the devices you want to the Backup media list box, click OK to return to the To select one or more devices for theīackup media box, click Add.

In the Backup media type box, select one of In this case, select Device to manuallyĬlick the browse (.) button to open the Select backup devices dialog box.

Note If the backup is taken from a different server, the destination server will not have the backup history informationįor the specified database. The list contains only databases that have been backed up according to the Select the database to restore from the drop-down list. On the General page, use the Source section to specify the source and location of the backup sets to restore. Right-click Databases, and then click Restore Database.Connect to the appropriate instance of the SQL Server Database Engine, and then in Object Explorer, click the server name to expand.

To restore a database to a new location, and optionally rename the database Note steps 4 and 7 are important to set so as not to overwrite the existing database. If they were, kill them.įor SQL Server 2012, using Sql Server Management Studio, I found these steps from the Microsoft page useful to restore to a different database file and name: (ref: ) Verify from the Activity Monitor Screen that no new processes were spawned.Do the same with the log file file name.Important: Change the 'Restore As' Rows Data file name to the file name of the existing database you wish to overwrite or just give it a new name.Select Overwrite the existing database (WITH REPLACE).Select the backup set you wish to restore from by selecting the check box to the left of the backup set.and choose the backup file of the other database you wish to restore from. Select the 'From Device:' radio button.Right click on the database you wish to restore, and select Tasks->Restore->From Database.Kill all running processes by right clicking on each process and selecting 'kill process'. Filter by the database you want to restore. From the toolbar, click the Activity Monitor button.For an existing database that you wish to 'restore: from a backup of a different database follow these steps:

Apex sql recovery key