In this fast moving world, data is the heart and soul of any enterprise. It has become an essential task for organizations around the world to protect their data. Database Administrators have a tough job to implement database backup and disaster recovery plans. Backing up your databases can protect an organization against the accidental loss of data, database corruption, hardware/operating system crashes or any natural disasters. Unfortunately if you dont have proper database backups then you are left with nothing to fall back on. As a DBA you need to make sure that the databases are backed up regularly and the backup tapes are stored in a secure location.
This article shows how a database can be restored to achieve point in time recovery.
[From SQL Server Performance]