• SanDroid (4/7/2011)


    Perhapse you can explain the question and provide refference material for your only correct answer?

    Did you read the information that he linked to about the version store? From: http://blogs.msdn.com/b/sqlserverstorageengine/archive/2009/01/01/managing-tempdb-in-sql-server-tempdb-basics-version-store-growth-and-removing-stale-row-versions.aspx

    One important point that I did not mention earlier is the “insert” into the Append-Only store are not logged. Why? Well if SQL Server has to fail, all active transactions will be rolled back anyways so the SQL Server does not need the “state” of version store as of the time when SQL Server stopped.

    I found another post by a Microsoft employee stating that the version store data is the only thing not logged, but I can't find it again right now.