June 25, 2002 at 2:49 pm
KB article:
"SQL Server 2000 supports a new feature that allows users to insert a named transaction in the transaction log and allow recovery to that point, similar to point-in-time recovery as implemented in SQL Server 7.0. In addition, these marks are tracked in the msdb database, enabling users to determine what marks are available and plan recovery accordingly."
Does anyone use this method for recovery?
Why / Why not?
June 25, 2002 at 3:12 pm
Haven't used them mainly because I haven't had any transactions that I use that fit.
If I did a specific update and was concerned about rolling back to that point, I might manually perform a transaction with a name, specifically to use this.
Steve Jones
June 25, 2002 at 4:16 pm
Havent had a need for it either. Guess I should look for more complicated problems!
Andy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply