Quote:
Originally Posted by nujd00
how to restore , im using mssql 2014
|
1. Open Microsoft SQL Server Management Studio 2014, and navigate to Databases.
2. Right-click Databases, and click on
Tasks > Restore > Databases..
In the Source for restore section, select From Device, and click the browse button.
3. Click Add in the Specify Backup window. Browse to the location of your restored database.
4. Click OK; the Specify Backup window displays.
5. Click OK. In the Destination for restore section, select the database to which you wish to restore, and in the Select the backup sets to restore section, select the backup file you selected above in step 3.
6.In the left pane, click Options, and select the following:
In the Restore options section, select Overwrite the existing database (WITH REPLACE), and leave the other options unselected.
7. Click OK to perform the restore.