Backup Part-3

 Q: What are the different types of Recovery Model?

·         Simple: transaction log backups are not supported by the simple recovery model.

·         Full: you can take all data and log full backup.

·         Bulk logged: Reduces log space usage by using minimal logging for most bulk operations.

Q: What do you know about the online backup?

In addition to doing backups to your local disks there are several companies that offer online backups via the internet.  Instead of you have to manage your backup files locally these services allow you to backup your databases via the internet and therefore you have an external copy stored outside of your company’s network.

Q: What is your suggestion for the SQL Server backup plan?

Establish a full backup schedule either on a multi-day, daily, weekly or monthly basis.

Incorporate differential backups into the plan to increase the available recovery points between full backups. (e.g take after every 3 to 4 hour)

If additional points in time are needed, then consider transaction log backups as a solution to meet a final level of granularity for recovery purposes. (e.g take after every 10 min)

Q: What is the value of DatabasebackupLSN for the first full backup file?

A DatabaseBackupLSN is a zero and FirstLSN is same as CheckpointLSN.

Q: What is First LSN?

The log sequence number (LSN) of the first transaction in the backup set. Blank for file backups.

Q: What is Last LSN?

The log sequence number (LSN) of the last transaction in the backup set. Blank for file backups.

Q: What is Full LSN?

The log sequence number (LSN) of the most recent full database backup.

Q: How to find LSN information of the Database Backup Files?

SELECT last_log_backup_lsn FROM sys.database_recovery_status WHERE database_id = DB_ID();

Please visit other related articles...

https://sqldbaiq.blogspot.com/p/backup-iq.html
https://sqldbaiq.blogspot.com/p/backuprestore-part-2.html
https://sqldbaiq.blogspot.com/p/backuprestore-part-3.html
https://sqldbaiq.blogspot.com/p/backuprestore-part-4.html
https://sqldbaiq.blogspot.com/p/backuprestore-part-5.html
https://sqldbaiq.blogspot.com/p/backuprestore-part-6.html
https://sqldbaiq.blogspot.com/p/backuprestore-part-7.html

https://sqldbaiq.blogspot.com/p/backuprestore-part-8.html

References: Thanks to the all the SQL Server bloggers who wrote and shared the valuable information on their blogs which helped me a lot to prepare this series of Questions. Also big thanks to Microsoft Documentation which contains each and everything about their product.