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
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