SQLTeam.com | Weblogs | Forums

STOPBEFOREMARK in SQL Server Database?

tsql
sql2008

#1

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?


#2

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.