How to restore SQL Server databases _mssql

How to restore a backup from a backup device (Enterprise Manager)
Restore a backup from a backup device

Expand the server group, and then expand the server.

Expand the Databases folder, right-click the database, point to All Tasks submenu, and then click Restore Database.

In the Revert to database box, enter or select the database name that you want to restore differently than the default database name that is displayed. To restore the database with a new name, enter a new database name.

Note Specifying a new name for the database automatically assigns a new name to the database file that is restored from the database backup.

Click From Device, and then click Select Device.

Under Restore from, click Tape or disk, and then select the Restore device.
If the device does not appear, click Add to add an existing backup device or create a new backup device. In the Restore Database dialog box, click View Content and select the backup set that you want to restore.

Note This option scans the backup set for backup content information that may take a long time, especially when using tape devices. If you already know the backup set that you want to restore, enter the backup set number in Backup number.

Under Restore backup sets, do one of the following:
Click Database-Full to restore the database backup.

Click Database-diff to restore the differential database backup.

Click Transaction log to apply the transaction log backup.

Click Files or filegroups to restore a file or filegroup backup. Specifies the name of the file or filegroup.
Click the Options tab, and then do one of the following: (optional)
Click "Make database can continue to run but cannot restore other transaction logs" If there are no other transaction log backups to apply.

Click "Make database no longer running, but can restore additional transaction logs" If additional transaction log backups are to be applied.