Individual recovery scenarios vary widely, ranging from disk hardware failures to corrupted data files to accidentally dropped tables, and many points in between. In this section, we provide an overview of recovery procedures.
Restoring the database from the last backup
Applying the binary logs to bring the system completely up to date
If you do not have binary logging enabled, the best you can do is restore the system to the last full backup.