A database can be restored from a full backup, or from a differential backup plus the latest transaction log backup. After the database has been restored, the last transaction log backup should be reapplied to the restored database to bring it up to date.
In order to restore a database, you must have the following:
1. The backup of the database to restore.
2. The restore media for the database.
3. The server on which the database is to be …
