The exact deleted values are not logged in the online SQL Server transaction log, only the IDs of the pages that held the truncated records are logged. These pages are marked for overwriting in the database data file and the truncated data will be gone for good when the new transactions are written to these pages.
This myth is also based on the fact that these commands take little time to execute, they are almost instantaneous.
Find more information on the SQL Server transaction log topic in the 10 most important SQL Server transaction log myths article.© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Términos de uso Privacidad Cookie Preference Center