______________ helps to restore the database to the point where it failed.

Options
- File backup
- Differential Backups
- File log
- Transaction log Backups

CORRECT ANSWER : Transaction log Backups

Discussion Board
Hmmm..

Transaction log BACKUP, not transaction log.

Ardi 03-22-2017 12:47 AM

Transaction log

Transaction log helps to restore the database to the point where it failed. To restore a sql server database to point of failure , database's recovery model should not be "Simple" , because it needs transaction log backup. Using transaction log backup along with the last database backup and any previous transaction log backups helps to restore the database to the point at which it failed.

Prajakta Pandit 03-3-2017 06:04 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲