Home Forums Article Discussions Article Discussions by Author Discuss content posted by Duncan Pryde Restoring after TRUNCATE TABLE RE: Restoring after TRUNCATE TABLE

  • March 9, 2011 at 9:02 am

    #1296579

    Steve Jones - SSC Editor (3/9/2011)

    It's clear to me, and if you think there is some implication that you are restoring to some specific point in time, you are reading something into the question that is not there. The question asks simply if you can restore to a point in time, and you can, based on the transaction log backups. The truncate statement is listed to see if you think this affects your log backup/recovery, which it doesn't.

    I'm sure you've read something about this on the Internet, but it's not true.

    Thanks Steve. That's sums up my intentions when writing the question.