SQL Server allows a log backup to be created even when all data files are not available for the database. This is very useful in restoring the transactions that occurred right before disaster occurred.

The BACKUP LOG command has an option NO_TRUNCATE which allows us to create a log backup when database is inaccessible. To […]