What is the backup strategy for the biggest database you handled?

Question

Accepted Answer

The backup strategy for the biggest database I handled involved regular full backups, daily differential backups, and hourly transaction log backups.

Regular full backups were performed to capture the entire database.
Daily differential backups were taken to capture the changes since the last full backup.
Hourly transaction log backups were taken to capture the changes since the last differential backup.
Backups were stored on separate storage devices to ensure data redundancy.
Backup files were regularly tested for integrity and restoration process.
Backup retention policy was defined to retain backups for a specific period of time.
Backup logs were monitored to ensure successful completion of backups.
Backup files were encrypted to protect sensitive data during storage and transmission.

Accepted Answer

By using this backup strategy we can handle the databases

Every week Full Backup

Every Day Differential Backup

Every 1hr log Backup

Top DXC Technology MS SQL DBA interview questions & answers