• Ignacio A. Salom Rangel (4/7/2011)


    SanDroid check this link http://technet.microsoft.com/en-us/magazine/gg552991.aspx

    Ignacio,

    Nice link. It helps prove my point.

    "The only truly non-logged operations in SQL Server are those affecting the version store in tempdb, which supports features like snapshot isolation and online index operations. These can be non-logged because there’s never a need to roll back a version store operation [/i]or run crash-recovery on the tempdb database."

    This article talks about logging version store operations.

    The question specificly states "Data affecting the version store".

    They are two differant things, two differant concepts.

    Version store operations, and version store data are completely differant things.

    Still waiting to hear from WayneS becuase I would not be supprised if he edited this question from "Data" to "operations", but we are seeing the un-edited version.