Restoring a database using STOPATMARK

This post will demonstrate how to restore a database from a log file up to a certain LSN (typically the one right before the transaction that destroyed the data.

[tsql]
RESTORE LOG AdventureWorks FROM DISK = ‘c:\adventureworks_log.bak’ WITH STOPATMARK = ‘lsn:15000000040000037’
GO
[/tsql]

https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/recover-to-a-log-sequence-number-sql-server?view=sql-server-2017

Views – 124