Sample Header Ad - 728x90

Can Transact-SQL snapshot backups be used to recover from database corruption?

-2 votes
0 answers
63 views
The most typical corruption recovery scenario involves using a [full database backup](https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/create-a-full-database-backup-sql-server?view=sql-server-ver17) from before corruption struck and every [transaction log backup](https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/back-up-a-transaction-log-sql-server?view=sql-server-ver17) between then and now. I have recently discovered [Transact-SQL snapshot backups](https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/create-a-transact-sql-snapshot-backup?view=sql-server-ver17) . Like full backups, you can replay transaction logs on top of them. As this Microsoft diagram shows Transact-SQL snapshot backups flowchart Does this suggest that Transact-SQL snapshot backups can be used to recover from database corruption, just like full database backups can?
Asked by J. Mini (1225 rep)
Jul 11, 2025, 08:13 PM