SQLTeam.com | Weblogs | Forums

STOPBEFOREMARK in SQL Server Database?



While reading SQL Server transaction logs with fn_dblog() function my friend suggest me to use STOPBEFOREMARK to recover Deleted data. But I have a little bit confusion about this command is when can i use this command to recover my lost or deleted transactions?


All the information that you want is described on this page and on links on that page.

You need to insert a mark and then at a later point, you will be able to recover to that point. SQL Server has other methods of recovery as well - for example point in time recovery.

Paul Randal has an article that describes STOPBEFOREMARK very nicely.