SQL Server Database Administrator Interview Questions and Answers for Freshers

The different types of Database backups include full, differential, transaction log, and filegroup backups.

• Full backup: A complete backup of the entire database.

• Differential backup: Backup of only the changes made since the last full backup.

• Transaction log backup: Backup of the transaction log, allowing point-in-time recovery.

• Filegroup backup: Backup of specific filegroups within a database.

Recovery models determine how SQL Server manages transaction log files and provides options for data recovery.

• Full recovery model: Allows for complete data recovery by storing all transactions in the transaction log.

• Simple recovery model: Automatically reclaims log space to keep the log file small, but limits recovery options.

• Bulk-logged recovery model: Minimally logs bulk operations, reducing log space usage but increasing potential for data loss.

• Examples: Full recovery mode...read more