Restoring a Database to a Prior State
At times, you may want to restore your database to an earlier point in time. For example, if an earlier transaction within a database changed some data incorrectly, you will need to restore the database to a point in time earlier than the incorrect data entry. To do this, recover the entire database to a point within a transaction log. You can recover a database to either a specific point in time within a transaction log or to a named mark that was previously inserted into the log.
To create a transaction log backup
To backup the transaction log when the database is damaged
To restore to the point of failure