Backup strategy involves making full backup on every Saturday night, differential backup every day and transaction log backup every hour. The database crashes. How do you restore?
A. Restore the latest full backup
B. Restore all differential backups in sequence
C. Restore all differential backups after the full backup in sequence
D. Restore all transaction log backups
Answer:A
Backup strategy involves making full backup on every Saturday night, differential backup every day and transaction log backup every hour. The database crashes. How do you restore?
A. Restore the latest full backup B. Restore all differential backups in sequence C. Restore all differential backups after the full backup in sequence D. Restore all transaction log backups